metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

6 rows where analysis = "blastn", 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
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

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