metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA613025" and tax_phylum = "Chordata"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4419032	4419032	PRJNA613025_S_NODE_11104_length_361_cov_1.615385_g10950_i0	PRJNA613025	11104	361	1.615385	5.83153985	Metazoa	33208	Chordata	Chordata	99.4	2.29e-22	NR	XP_042309334.1	8520	g10950	i0	67.5	38.8005540166205	83	24	66.5	1	361	122	191	273	XP_042309334.1 40S ribosomal protein S6 [Sceloporus undulatus]	diamond	14007	100	0.994	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Phrynosomatidae	Sceloporus	Sceloporus undulatus
27459651	27459651	PRJNA613025_S_NODE_30443_length_166_cov_2.794872_g30289_i0	PRJNA613025	30443	166	2.794872	4.63948752	Branchiostoma floridae	7739	Chordata	Chordata	48.5	1.18e-4	NR	XP_035660211.1	7739	g30289	i0	52.6	1.46385542168675	38	18	68.7	0	164	51	1509	1546	XP_035660211.1 uncharacterized protein LOC118404933 [Branchiostoma floridae]	diamond	243	48.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma floridae
28248641	28248641	PRJNA613025_S_NODE_19346_length_226_cov_1.096045_g19192_i0	PRJNA613025	19346	226	1.096045	2.4770617	Lampetra planeri	7750	Chordata	Chordata	43.9	0.00145	NR	CAL5921959.1	7750	g19192	i0	51.1	0.623893805309734	47	21	61.1	2	196	59	1	46	CAL5921959.1 unnamed protein product [Lampetra planeri]	diamond	141	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
28514484	28514484	PRJNA613025_S_NODE_31487_length_165_cov_0.879310_g31333_i0	PRJNA613025	31487	165	0.87931	1.4508615	Metazoa	33208	Chordata	Chordata	42	0.012	NR	NP_031822.2	10090	g31333	i0	53.1	5.69090909090909	32	15	58.2	0	161	66	65	96	NP_031822.2 protein CTLA-2-alpha isoform a precursor [Mus musculus]	diamond	939	42.4	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
28691081	28691081	PRJNA613025_S_NODE_29767_length_168_cov_1.285714_g29613_i0	PRJNA613025	29767	168	1.285714	2.15999952	Latimeria chalumnae	7897	Chordata	Chordata	57	1.64e-8	NR	XP_005996654.1	7897	g29613	i0	50	7.46428571428571	52	23	92.9	1	160	5	30	78	XP_005996654.1 large ribosomal subunit protein eL22 isoform X3 [Latimeria chalumnae]	diamond	1254	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
29177669	29177669	PRJNA613025_S_NODE_27529_length_177_cov_1.031250_g27375_i0	PRJNA613025	27529	177	1.03125	1.8253125	Chordata	7711	Chordata	Chordata	44.3	0.00423	NR	XP_039592720.1	55291	g27375	i0	58.6	40.3050847457627	58	24	98.3	0	3	176	201	258	XP_039592720.1 ubiquitin-conjugating enzyme E2Q-like protein 1 [Polypterus senegalus]	diamond	7134	44.7	0.991051454138702	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Polypterus	Polypterus senegalus
29650704	29650704	PRJNA613025_S_NODE_24370_length_192_cov_1.062937_g24216_i0	PRJNA613025	24370	192	1.062937	2.04083904	Metazoa	33208	Chordata	Chordata	42.4	0.00885	NR	NP_001083630.1	8355	g24216	i0	67.9	2.640625	28	9	43.8	0	192	109	38	65	NP_001083630.1 ribosomal protein, large, P1 L homeolog [Xenopus laevis]	diamond	507	42.7	0.992974238875878	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
29985513	29985513	PRJNA613025_S_NODE_11131_length_360_cov_2.620579_g10977_i0	PRJNA613025	11131	360	2.620579	9.4340844	Phodopus roborovskii	109678	Chordata	Chordata	174	2.0899999999999994e-52	NR	XP_051057148.1	109678	g10977	i0	75	9.275	112	28	93.3	0	2	337	99	210	XP_051057148.1 60S ribosomal protein L27a-like [Phodopus roborovskii]	diamond	3339	175	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Phodopus	Phodopus roborovskii
30535624	30535624	PRJNA613025_S_NODE_11233_length_358_cov_1.485437_g11079_i0	PRJNA613025	11233	358	1.485437	5.31786446	Bovidae	9895	Chordata	Chordata	231	2.46e-71	NR	NP_803461.2	9913	g11079	i0	100	5.98324022346369	119	0	99.7	0	1	357	174	292	NP_803461.2 DNA nucleotidylexotransferase [Bos taurus]	diamond	2142	231	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos taurus
32546651	32546651	PRJNA613025_S_NODE_8719_length_443_cov_4.398477_g8567_i0	PRJNA613025	8719	443	4.398477	19.48525311	Bufotes viridis	30338	Chordata	Chordata	131	5e-35	NR	CAK8641430.1	30338	g8567	i0	56.7	0.812641083521445	120	50	80.6	2	1	357	102	220	CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis]	diamond	360	131	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
32735614	32735614	PRJNA613025_S_NODE_22360_length_203_cov_2.149351_g22206_i0	PRJNA613025	22360	203	2.149351	4.36318253	Lamprotornis superbus	245042	Chordata	Chordata	87	4.78e-19	NR	KAI1234130.1	245042	g22206	i0	67.2	8.00985221674877	64	19	94.6	1	1	192	119	180	KAI1234130.1 hypothetical protein IHE44_0003845 [Lamprotornis superbus]	diamond	1626	87	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sturnidae	Lamprotornis	Lamprotornis superbus

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;