metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1025141" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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
1437580	1437580	PRJNA1025141_P_NODE_5762_length_334_cov_1.180077_g5701_i0	PRJNA1025141	5762	334	1.180077	3.94145718	Flavobacterium sp. N502540	2986838	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2324023906\|gb\|CP110012.1\|	2986838	g5701	i0	100	0.0868263473053892	29	0	9	0	15	43	1707003	1706975	Flavobacterium sp. N502540 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N502540
3989279	3989279	PRJNA1025141_P_NODE_10364_length_249_cov_0.875000_g10303_i0	PRJNA1025141	10364	249	0.875	2.17875	Flavobacterium sp. N2038	2986829	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2324023810\|gb\|CP110001.1\|	2986829	g10303	i0	99.197	529.473895582329	249	2	100	0	1	249	1153349	1153101	Flavobacterium sp. N2038 chromosome, complete genome	blastn	131839	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
4832182	4832182	PRJNA1025141_P_NODE_6104_length_324_cov_1.227092_g6043_i0	PRJNA1025141	6104	324	1.227092	3.97577808	Bacteroidota	976	Bacteria	Bacteria	368	2.66e-97	NTclustered	gi\|2713796288\|gb\|CP150661.1\|	218490	g6043	i0	89.073	394.824074074074	302	26	92	7	7	304	1134817	1134519	Polaribacter butkevichii strain KCTC 12100 chromosome, complete genome	blastn	127923	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter butkevichii
11207456	11207456	PRJNA1025141_P_NODE_4929_length_365_cov_1.582192_g4868_i0	PRJNA1025141	4929	365	1.582192	5.7750008	Flavisolibacter	398041	Bacteria	Bacteria	664	0	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g4868	i0	99.452	262.586301369863	365	2	100	0	1	365	4834159	4833795	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	95844	664	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
11641453	11641453	PRJNA1025141_P_NODE_7330_length_293_cov_0.981818_g7269_i0	PRJNA1025141	7330	293	0.981818	2.87672674	Aquirufa antheringensis	2516559	Bacteria	Bacteria	200	9.17e-47	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g7269	i0	79.264	569.293515358362	299	53	100	9	1	293	213181	212886	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	166803	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
15465654	15465654	PRJNA1025141_P_NODE_9373_length_251_cov_0.865169_g9312_i0	PRJNA1025141	9373	251	0.865169	2.17157419	Maribacter sp. R86514	3093854	Bacteria	Bacteria	167	7.789999999999999e-37	NTclustered	gi\|2845113958\|gb\|CP138999.1\|	3093854	g9312	i0	80.93	55.8486055776892	215	37	85	4	37	249	1501042	1501254	Maribacter sp. R86514 chromosome, complete genome	blastn	14018	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	Maribacter sp. R86514
16306599	16306599	PRJNA1025141_P_NODE_6333_length_318_cov_0.942857_g6272_i0	PRJNA1025141	6333	318	0.942857	2.99828526	Saprospira	1007	Bacteria	Bacteria	486	6.889999999999999e-133	NTclustered	gi\|378573745\|gb\|CP002831.1\|	984262	g6272	i0	94.357	355.569182389937	319	15	100	3	1	318	1963729	1963413	Saprospira grandis str. Lewin, complete genome	blastn	113071	486	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira grandis
18014705	18014705	PRJNA1025141_P_NODE_7135_length_297_cov_1.321429_g7074_i0	PRJNA1025141	7135	297	1.321429	3.92464413	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	429	1.09e-115	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g7074	i0	92.929	480.616161616162	297	17	100	2	1	297	217377	217085	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	142743	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
18014722	18014722	PRJNA1025141_P_NODE_8255_length_273_cov_1.020000_g8194_i0	PRJNA1025141	8255	273	1.02	2.7846	Chryseobacterium indologenes	253	Bacteria	Bacteria	472	1.62e-128	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g8194	i0	97.802	524.875457875458	273	6	100	0	1	273	2943773	2943501	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	143291	472	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
19288427	19288427	PRJNA1025141_P_NODE_10796_length_247_cov_0.885057_g10735_i0	PRJNA1025141	10796	247	0.885057	2.18609079	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	106	1.69e-18	NTclustered	gi\|2556925782\|gb\|CP129489.1\|	2021391	g10735	i0	90.123	3.32793522267206	81	8	33	0	84	164	895998	896078	MAG: Flavobacteriales bacterium isolate cMAG.7 chromosome, complete genome	blastn	822	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
19288464	19288464	PRJNA1025141_P_NODE_12876_length_241_cov_1.523810_g12815_i0	PRJNA1025141	12876	241	1.52381	3.6723821	Chryseobacterium indologenes	253	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|1158824264\|gb\|CP018786.1\|	253	g12815	i0	97.51	520.44398340249	241	6	100	0	1	241	457395	457155	Chryseobacterium indologenes strain AA5 chromosome, complete genome	blastn	125427	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes

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