metadata: contig_metadata: 15 rows where bioproject = "PRJNA1237347", tax_clade = "Opisthokonta" and tax

15 rows where bioproject = "PRJNA1237347", tax_clade = "Opisthokonta" and tax_phylum = "Gastrotricha"

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_order	tax_family	tax_genus	tax_species
7425863	7425863	PRJNA1237347_P_NODE_254306_length_370_cov_1084.161616_g247733_i0	PRJNA1237347	254306	370	1084.161616	4011.3979792	Chaetonotidae	41372	Gastrotricha	other_Eukaryota	676	0	NTclustered	gi\|389075443\|gb\|JN185481.1\|	1194616	g247733	i0	99.73	100.083783783784	370	0	100	1	1	370	881	513	Lepidodermella squamata voucher TK173 18S ribosomal RNA gene, partial sequence	blastn	37031	676	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
7998837	7998837	PRJNA1237347_P_NODE_565147_length_228_cov_622.180645_g558573_i0	PRJNA1237347	565147	228	622.180645	1418.5718706	Paucitubulatina gen. n. sp. d AM-2025	3396420	Gastrotricha	other_Eukaryota	348	2.3100000000000002e-91	NTclustered	gi\|2896106088\|gb\|PV033544.1\|	3396420	g558573	i0	97.101	90.6140350877193	207	4	90	2	23	228	1538	1333	Paucitubulatina gen. n. sp. d AM-2025 voucher C1 large subunit ribosomal RNA gene, partial sequence	blastn	20660	348	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida			Paucitubulatina gen. n. sp. d AM-2025
9273570	9273570	PRJNA1237347_P_NODE_560988_length_235_cov_913.382716_g554415_i0	PRJNA1237347	560988	235	913.382716	2146.4493826	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	399	6.529999999999999e-107	NTclustered	gi\|478683567\|gb\|KC193103.1\|	1194616	g554415	i0	97.447	99.931914893617	235	4	100	2	1	235	2931	2699	Lepidodermella squamata 28S ribosomal RNA gene, partial sequence	blastn	23484	399	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
10545637	10545637	PRJNA1237347_P_NODE_353709_length_301_cov_1.543860_g347136_i0	PRJNA1237347	353709	301	1.54386	4.6470186	Chaetonotus sp. p AK-2024	3232324	Gastrotricha	other_Eukaryota	276	1.53e-69	NTclustered	gi\|2755229202\|gb\|PP996338.1\|	3232324	g347136	i0	83.278	71.375415282392	299	50	99	0	3	301	1011	713	Chaetonotus sp. p AK-2024 isolate W6 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	21484	276	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Chaetonotus	Chaetonotus sp. p AK-2024
13094699	13094699	PRJNA1237347_P_NODE_321851_length_319_cov_1358.760163_g315278_i0	PRJNA1237347	321851	319	1358.760163	4334.44491997	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	532	8.76e-147	NTclustered	gi\|478683567\|gb\|KC193103.1\|	1194616	g315278	i0	98.35	95.9561128526646	303	5	95	0	1	303	1828	2130	Lepidodermella squamata 28S ribosomal RNA gene, partial sequence	blastn	30610	532	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
15642903	15642903	PRJNA1237347_P_NODE_270413_length_356_cov_3.540636_g263840_i0	PRJNA1237347	270413	356	3.540636	12.60466416	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	364	3.809999999999998e-96	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g263840	i0	85.112	1	356	53	100	0	1	356	6752	7107	Lepidodermella squamata mitochondrion, complete genome	blastn	356	364	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
16351042	16351042	PRJNA1237347_P_NODE_358513_length_298_cov_216.368889_g351940_i0	PRJNA1237347	358513	298	216.368889	644.77928922	Lepidodermella	41322	Gastrotricha	other_Eukaryota	335	2.46e-87	NTclustered	gi\|1418591758\|gb\|MF325900.1\|	2259395	g351940	i0	93.778	73.2986577181208	225	11	74	2	77	298	3629	3405	Lepidodermella polaris isolate AMU234.16 28S ribosomal RNA gene, partial sequence	blastn	21843	335	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella polaris
16913498	16913498	PRJNA1237347_P_NODE_106474_length_654_cov_18.285714_g100029_i0	PRJNA1237347	106474	654	18.285714	119.58856956	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	1155	0	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g100029	i0	98.476	9.72782874617737	656	8	100	2	1	654	7637	8292	Lepidodermella squamata mitochondrion, complete genome	blastn	6362	1155	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
18193013	18193013	PRJNA1237347_P_NODE_345635_length_305_cov_310.573276_g339062_i0	PRJNA1237347	345635	305	310.573276	947.2484918	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	531	2.9999999999999993e-146	NTclustered	gi\|389075633\|gb\|JN185525.1\|	1194616	g339062	i0	98.033	100.567213114754	305	6	100	0	1	305	1112	808	Lepidodermella squamata voucher TK173 28S ribosomal RNA gene, partial sequence	blastn	30673	531	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
22019313	22019313	PRJNA1237347_P_NODE_403958_length_278_cov_1.234146_g397385_i0	PRJNA1237347	403958	278	1.234146	3.43092588	Lepidodermella sp. DMW-2003	249249	Gastrotricha	other_Eukaryota	377	3.72e-100	NTclustered	gi\|37675450\|gb\|AY394702.1\|	249249	g397385	i0	91.304	73.6906474820144	276	24	99	0	1	276	452	727	Lepidodermella sp. DMW-2003 82kD heat-shock protein, partial sequence	blastn	20486	377	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella sp. DMW-2003
23290197	23290197	PRJNA1237347_P_NODE_172259_length_478_cov_130.871605_g165688_i0	PRJNA1237347	172259	478	130.871605	625.5662719	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	804	0	NTclustered	gi\|389075619\|gb\|JN185518.1\|	1194616	g165688	i0	97.071	101.39539748954	478	12	100	2	1	478	349	824	Lepidodermella squamata voucher TK163 28S ribosomal RNA gene, partial sequence	blastn	48467	804	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
24566344	24566344	PRJNA1237347_P_NODE_278720_length_349_cov_468.579710_g272147_i0	PRJNA1237347	278720	349	468.57971	1635.3431879	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	623	5.569999999999999e-174	NTclustered	gi\|478683567\|gb\|KC193103.1\|	1194616	g272147	i0	98.854	100.114613180516	349	4	100	0	1	349	2151	2499	Lepidodermella squamata 28S ribosomal RNA gene, partial sequence	blastn	34940	623	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
24570367	24570367	PRJNA1237347_P_NODE_48860_length_1070_cov_6.491474_g43991_i0	PRJNA1237347	48860	1070	6.491474	69.4587718	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	1888	0	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g43991	i0	98.506	11.5766355140187	1071	15	100	1	1	1070	9457	8387	Lepidodermella squamata mitochondrion, complete genome	blastn	12387	1888	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
29283574	29283574	PRJNA1237347_P_NODE_450349_length_259_cov_1.413978_g443776_i0	PRJNA1237347	450349	259	1.413978	3.66220302	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	100	1.39e-22	NR	YP_009136573.1	1194616	g443776	i0	90.7	0.625482625482625	54	5	62.5	0	163	2	1	54	YP_009136573.1 NADH dehydrogenase subunit 5 [Lepidodermella squamata]	diamond	162	100	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
32191376	32191376	PRJNA1237347_P_NODE_431918_length_266_cov_2.388601_g425345_i0	PRJNA1237347	431918	266	2.388601	6.35367866	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	160	3.71e-46	NR	YP_009136579.1	1194616	g425345	i0	95.5	0.992481203007519	88	4	99.2	0	265	2	164	251	YP_009136579.1 NADH dehydrogenase subunit 2 [Lepidodermella squamata]	diamond	264	160	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata

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