metadata: contig_metadata: 9 rows where bioproject = "PRJNA681822" and tax

9 rows where bioproject = "PRJNA681822" 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
654154	654154	PRJNA681822_P_NODE_31701_length_669_cov_4.179530_g30313_i0	PRJNA681822	31701	669	4.17953	27.9610557	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	760	0	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g30313	i0	87.145	1.15545590433483	669	86	100	0	1	669	10313	10981	Lepidodermella squamata mitochondrion, complete genome	blastn	773	760	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
657218	657218	PRJNA681822_P_NODE_89761_length_407_cov_2.311377_g88279_i0	PRJNA681822	89761	407	2.311377	9.40730439	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	248	2.1800000000000003e-79	NR	YP_009136570.1	1194616	g88279	i0	89.6	0.995085995085995	135	14	99.5	0	3	407	122	256	YP_009136570.1 cytochrome b [Lepidodermella squamata]	diamond	405	248	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
12133941	12133941	PRJNA681822_P_NODE_342730_length_262_cov_2.291005_g341241_i0	PRJNA681822	342730	262	2.291005	6.0024331	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	268	2.1799999999999998e-67	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g341241	i0	85.441	1.97709923664122	261	35	99	3	1	260	6174	5916	Lepidodermella squamata mitochondrion, complete genome	blastn	518	268	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
14683150	14683150	PRJNA681822_P_NODE_29952_length_690_cov_2.802269_g28584_i0	PRJNA681822	29952	690	2.802269	19.3356561	Chaetonotus sp. p AK-2024	3232324	Gastrotricha	other_Eukaryota	575	3.299999999999999e-159	NTclustered	gi\|2755229202\|gb\|PP996338.1\|	3232324	g28584	i0	81.805	78.8695652173913	687	124	99	1	3	688	514	1200	Chaetonotus sp. p AK-2024 isolate W6 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	54420	575	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Chaetonotus	Chaetonotus sp. p AK-2024
21054509	21054509	PRJNA681822_P_NODE_14117_length_1015_cov_14.550955_g13062_i0	PRJNA681822	14117	1015	14.550955	147.69219325	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	1792	0	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g13062	i0	98.522	12.079802955665	1015	15	100	0	1	1015	8414	9428	Lepidodermella squamata mitochondrion, complete genome	blastn	12261	1792	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
21054997	21054997	PRJNA681822_P_NODE_172237_length_326_cov_0.889328_g170749_i0	PRJNA681822	172237	326	0.889328	2.89920928	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	398	3.4199999999999996e-106	NTclustered	gi\|817528470\|ref\|NC_026985.1\|	1194616	g170749	i0	88.65	2.18711656441718	326	37	100	0	1	326	9886	9561	Lepidodermella squamata mitochondrion, complete genome	blastn	713	398	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
22333811	22333811	PRJNA681822_P_NODE_493078_length_226_cov_2.888889_g491588_i0	PRJNA681822	493078	226	2.888889	6.52888914	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	329	8.3e-86	NTclustered	gi\|389075756\|gb\|JN185551.1\|	1194616	g491588	i0	93.636	89.3982300884956	220	14	97	0	1	220	255	474	Lepidodermella squamata voucher TK163 cytochrome c oxidase subunit I gene, partial cds; mitochondrial	blastn	20204	329	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Lepidodermella	Lepidodermella squamata
31314311	31314311	PRJNA681822_P_NODE_168295_length_328_cov_1.780392_g166807_i0	PRJNA681822	168295	328	1.780392	5.83968576	Litigonotus ghinii	3104745	Gastrotricha	other_Eukaryota	116	6.9e-30	NR	XCN99738.1	3104745	g166807	i0	71.3	0.859756097560976	94	27	86	0	2	283	17	110	XCN99738.1 ATP synthase F0 subunit 6 [Litigonotus ghinii]	diamond	282	116	1	Eukaryota	Opisthokonta	Metazoa	Gastrotricha	Chaetonotida	Chaetonotidae	Litigonotus	Litigonotus ghinii
32611193	32611193	PRJNA681822_P_NODE_118600_length_369_cov_2.375000_g117113_i0	PRJNA681822	118600	369	2.375	8.76375	Lepidodermella squamata	1194616	Gastrotricha	other_Eukaryota	182	6.3e-53	NR	YP_009136572.1	1194616	g117113	i0	96.8	0.772357723577236	95	3	77.2	0	1	285	153	247	YP_009136572.1 NADH dehydrogenase subunit 4 [Lepidodermella squamata]	diamond	285	182	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);;