metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA806354" and tax_phylum = "Bacteroidota"

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
3774183	3774183	PRJNA806354_P_NODE_41863_length_236_cov_2.245399_g41754_i0	PRJNA806354	41863	236	2.245399	5.29914164	Weeksellaceae	2762318	Bacteria	Bacteria	435	1.8e-117	NTclustered	gi\|2620028799\|gb\|CP084355.1\|	34085	g41754	i0	100	357.487288135593	235	0	99	0	2	236	1137555	1137789	Riemerella anatipestifer strain RA-PNBC-21-0706-AS chromosome	blastn	84367	435	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella anatipestifer
4634548	4634548	PRJNA806354_P_NODE_8764_length_473_cov_1.805000_g8655_i0	PRJNA806354	8764	473	1.805	8.53765	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	874	0	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g8655	i0	100	236.947145877378	473	0	100	0	1	473	111510	111982	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	112076	874	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
11009946	11009946	PRJNA806354_P_NODE_40509_length_242_cov_0.911243_g40400_i0	PRJNA806354	40509	242	0.911243	2.20520806	Kaistella haifensis	421525	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g40400	i0	99.576	0.975206611570248	236	1	98	0	1	236	260714	260949	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	236	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
12701953	12701953	PRJNA806354_P_NODE_370_length_1864_cov_15.705193_g340_i0	PRJNA806354	370	1864	15.705193	292.74479752	Aquirufa	2676247	Bacteria	Bacteria	2128	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g340	i0	87.394	509.206545064378	1888	195	100	38	1	1864	360545	358677	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	949161	2137	0.99578848853533	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
13559577	13559577	PRJNA806354_P_NODE_28991_length_275_cov_1.742574_g28882_i0	PRJNA806354	28991	275	1.742574	4.7920785	Flavobacterium album	2175091	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|1387106870\|gb\|CP029186.1\|	2175091	g28882	i0	99.636	99.0254545454546	275	1	100	0	1	275	386385	386111	Flavobacterium album strain HYN0059 chromosome, complete genome	blastn	27232	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium album
15250476	15250476	PRJNA806354_P_NODE_12192_length_406_cov_1.426426_g12083_i0	PRJNA806354	12192	406	1.426426	5.79128956	Weeksellaceae	2762318	Bacteria	Bacteria	688	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g12083	i0	97.519	498.729064039409	403	8	99	2	5	406	2158672	2158271	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	202484	688	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
20348785	20348785	PRJNA806354_P_NODE_39876_length_243_cov_0.905882_g39767_i0	PRJNA806354	39876	243	0.905882	2.20129326	root	1	Root_unresolved	Root_unresolved	448	2.39e-121	NTclustered	gi\|930155685\|gb\|KR074424.1\|	837	g39767	i0	100	129.465020576132	242	0	99	0	2	243	530	771	Porphyromonas gingivalis strain CP33 16S ribosomal RNA gene, partial sequence	blastn	31460	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
21208405	21208405	PRJNA806354_P_NODE_4777_length_625_cov_1.597826_g4669_i0	PRJNA806354	4777	625	1.597826	9.9864125	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	1155	0	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g4669	i0	100	274.7184	625	0	100	0	1	625	112044	112668	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	171699	1155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
22482858	22482858	PRJNA806354_P_NODE_17538_length_344_cov_1.797048_g17429_i0	PRJNA806354	17538	344	1.797048	6.18184512	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	630	3.289999999999999e-176	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g17429	i0	99.709	409.627906976744	344	1	100	0	1	344	113350	113007	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	140912	630	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3

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