metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA397736" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA397736" and tax_kingdom = "Metazoa"

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
2962893	2962893	PRJNA397736_S_NODE_883_length_304_cov_3.774545_g847_i0	PRJNA397736	883	304	3.774545	11.4746168	Planorbella duryi	129831	Mollusca	Mollusca	492	1.41e-134	NTclustered	gi\|46451271\|gb\|AY577472.1\|	129831	g847	i0	100	84.1085526315789	266	0	88	0	1	266	266	1	Helisoma duryi 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	25569	492	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Planorbella	Planorbella duryi
4239195	4239195	PRJNA397736_S_NODE_2684_length_162_cov_1.669173_g2648_i0	PRJNA397736	2684	162	1.669173	2.70406026	Sus scrofa	9823	Chordata	Chordata	278	2.04e-70	NTclustered	gi\|165931778\|emb\|AM932505.1\|	9823	g2648	i0	98.113	67.7901234567901	159	3	100	0	1	159	279	437	Sus scrofa centromeric satellite repeat, clone Pg3	blastn	10982	278	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
4907909	4907909	PRJNA397736_S_NODE_184_length_676_cov_32.989181_g167_i0	PRJNA397736	184	676	32.989181	223.00686356	root	1	Root_unresolved	Root_unresolved	58.4	0.001	NTclustered	gi\|2304139023\|ref\|XM_050623139.1\|	85661	g167	i0	100	1.78994082840237	31	0	5	0	468	498	160	190	PREDICTED: Bombus huntii uncharacterized LOC126868013 (LOC126868013), transcript variant X1, mRNA	blastn	1210	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus huntii
5515841	5515841	PRJNA397736_S_NODE_145_length_754_cov_23.711724_g130_i0	PRJNA397736	145	754	23.711724	178.78639896	Exaiptasia diaphana	2652724	Cnidaria	other_Eukaryota	54.7	0.021	NTclustered	gi\|1191051559\|ref\|XM_021047964.1\|	2652724	g130	i0	100	0.0384615384615385	29	0	4	0	500	528	3818	3846	PREDICTED: Exaiptasia diaphana monocarboxylate transporter 10 (LOC110242031), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Aiptasiidae	Exaiptasia	Exaiptasia diaphana
5515844	5515844	PRJNA397736_S_NODE_1765_length_207_cov_5.820225_g1729_i0	PRJNA397736	1765	207	5.820225	12.04786575	Philodina citrina	468664	Rotifera	other_Eukaryota	231	2.17e-56	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g1729	i0	91.667	45.8647342995169	168	13	81	1	27	194	1875	2041	Philodina citrina complete mitochondrial genome	blastn	9494	231	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
8065467	8065467	PRJNA397736_S_NODE_287_length_556_cov_17.252372_g214_i2	PRJNA397736	287	556	17.252372	95.92318832	Demodex environmental sample	1856688	Arthropoda	Arthropoda	752	0	NTclustered	gi\|1040064834\|gb\|KU363928.1\|	1856688	g214	i2	91.47	98.089928057554	551	42	99	4	8	556	1	548	Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence	blastn	54538	752	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex environmental sample
10616031	10616031	PRJNA397736_S_NODE_1009_length_286_cov_3.747082_g973_i0	PRJNA397736	1009	286	3.747082	10.71665452	Blattella germanica	6973	Arthropoda	Arthropoda	527	3.5999999999999986e-145	NTclustered	gi\|357966808\|gb\|JF499929.1\|	6973	g973	i0	100	96.1398601398601	285	0	99	0	2	286	841	557	Blattella germanica isolate GRI-D22-2a small subunit ribosomal RNA gene, partial sequence	blastn	27496	527	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
11890937	11890937	PRJNA397736_S_NODE_1330_length_243_cov_5.934579_g1294_i0	PRJNA397736	1330	243	5.934579	14.42102697	Latimeria chalumnae	7897	Chordata	Chordata	54.7	0.006	NTclustered	gi\|2721749050\|ref\|XM_005986866.2\|	7897	g1294	i0	100	0.119341563786008	29	0	12	0	75	103	2346	2374	PREDICTED: Latimeria chalumnae frizzled-9 (LOC102349865), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Coelacanthiformes	Coelacanthidae	Latimeria	Latimeria chalumnae
13165892	13165892	PRJNA397736_S_NODE_851_length_311_cov_5.645390_g815_i0	PRJNA397736	851	311	5.64539	17.5571629	Pseudoterpna coronillaria	1007376	Arthropoda	Arthropoda	60.2	1.74e-4	NTclustered	gi\|2918369770\|emb\|OZ237837.1\|	1007376	g815	i0	89.583	0.154340836012862	48	3	15	2	261	308	5854513	5854558	Pseudoterpna coronillaria genome assembly, chromosome: 12	blastn	48	60.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Pseudoterpna	Pseudoterpna coronillaria
14441046	14441046	PRJNA397736_S_NODE_2052_length_189_cov_5.162500_g2016_i0	PRJNA397736	2052	189	5.1625	9.757125	Sus scrofa	9823	Chordata	Chordata	263	6.879999999999999e-66	NTclustered	gi\|2103\|emb\|X16513.1\|	9823	g2016	i0	93.258	41.3333333333333	178	12	100	0	11	188	417	240	Pig gender-neutral repetitive DNA	blastn	7812	263	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Suidae	Sus	Sus scrofa
18263781	18263781	PRJNA397736_S_NODE_1435_length_234_cov_4.039024_g1399_i0	PRJNA397736	1435	234	4.039024	9.45131616	Planorbella duryi	129831	Mollusca	Mollusca	394	3.02e-105	NTclustered	gi\|1150882693\|gb\|KY514384.1\|	129831	g1399	i0	97.021	90.4487179487179	235	5	100	2	1	234	2297	2530	Planorbella duryi mitochondrion, complete genome	blastn	21165	394	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Planorbella	Planorbella duryi
19537996	19537996	PRJNA397736_S_NODE_236_length_620_cov_19.473773_g214_i0	PRJNA397736	236	620	19.473773	120.7373926	Demodex environmental sample	1856688	Arthropoda	Arthropoda	942	0	NTclustered	gi\|1040064834\|gb\|KU363928.1\|	1856688	g214	i0	95.159	97.6290322580645	599	26	96	3	17	613	598	1	Demodex environmental sample clone K-7-14-37 28S ribosomal RNA gene, partial sequence	blastn	60530	942	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Demodicidae	Demodex	Demodex environmental sample
19537998	19537998	PRJNA397736_S_NODE_816_length_318_cov_4.148789_g780_i0	PRJNA397736	816	318	4.148789	13.19314902	Platynothrus peltifer	128015	Arthropoda	Arthropoda	52.8	0.03	NTclustered	gi\|2579718317\|gb\|CP133306.1\|	128015	g780	i0	100	0.0880503144654088	28	0	9	0	3	30	19738402	19738375	Platynothrus peltifer isolate 155_3 chromosome 1	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Camisiidae	Platynothrus	Platynothrus peltifer
22088653	22088653	PRJNA397736_S_NODE_558_length_389_cov_11.086111_g522_i0	PRJNA397736	558	389	11.086111	43.12497179	Physella acuta	109671	Mollusca	Mollusca	52.8	0.037	NTclustered	gi\|2572411827\|ref\|XM_059320587.1\|	109671	g522	i0	96.774	0.0796915167095116	31	1	8	0	160	190	2165	2135	PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Physidae	Physella	Physella acuta

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);;