metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA971593" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
1266144	1266144	PRJNA971593_P_NODE_11801_length_351_cov_2.823741_g11652_i0	PRJNA971593	11801	351	2.823741	9.91133091	Flavobacterium	237	Bacteria	Bacteria	649	0	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g11652	i0	100	404.609686609687	351	0	100	0	1	351	980619	980269	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	142018	649	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
4772470	4772470	PRJNA971593_P_NODE_14184_length_319_cov_2.552846_g14035_i0	PRJNA971593	14184	319	2.552846	8.14357874	uncultured Cloacibacterium sp.	904945	Bacteria	Bacteria	590	5.1299999999999986e-164	NTclustered	gi\|633869106\|gb\|KJ127995.1\|	904945	g14035	i0	100	104	319	0	100	0	1	319	4	322	Uncultured Cloacibacterium sp. clone NJFU_SLX-S131 16S ribosomal RNA gene, partial sequence	blastn	33176	590	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	uncultured Cloacibacterium sp.
4772629	4772629	PRJNA971593_P_NODE_25004_length_247_cov_0.885057_g24855_i0	PRJNA971593	25004	247	0.885057	2.18609079	Fluviicola taffensis	191579	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|327317519\|gb\|CP002542.1\|	755732	g24855	i0	86.694	1.00404858299595	248	31	100	2	1	247	3004663	3004909	Fluviicola taffensis DSM 16823 chromosome, complete genome	blastn	248	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
4772723	4772723	PRJNA971593_P_NODE_464_length_1502_cov_2.286214_g400_i0	PRJNA971593	464	1502	2.286214	34.33893428	Dyadobacter sp. 676	3088362	Bacteria	Bacteria	54.7	0.043	NTclustered	gi\|2752922223\|gb\|CP159289.1\|	3088362	g400	i0	94.286	0.0233022636484687	35	2	2	0	804	838	3474290	3474256	Dyadobacter sp. 676 chromosome, complete genome	blastn	35	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 676
6047379	6047379	PRJNA971593_P_NODE_1805_length_872_cov_2.151439_g1684_i0	PRJNA971593	1805	872	2.151439	18.76054808	Flavobacterium sp.	239	Bacteria	Bacteria	702	0	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g1684	i0	81.362	2.0355504587156	896	137	99	24	3	872	1355757	1354866	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	1775	702	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
7322406	7322406	PRJNA971593_P_NODE_28906_length_241_cov_0.916667_g28757_i0	PRJNA971593	28906	241	0.916667	2.20916747	Chryseobacterium sp. PMSZPI	1033900	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2894512347\|gb\|CP178384.1\|	1033900	g28757	i0	100	0.116182572614108	28	0	12	0	146	173	914634	914661	Chryseobacterium sp. PMSZPI chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. PMSZPI
7644231	7644231	PRJNA971593_P_NODE_12246_length_345_cov_1.893382_g12097_i0	PRJNA971593	12246	345	1.893382	6.5321679	Cloacibacterium	501783	Bacteria	Bacteria	632	9.17e-177	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g12097	i0	99.71	475.173913043478	345	1	100	0	1	345	131154	131498	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	163935	632	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
10194879	10194879	PRJNA971593_P_NODE_10828_length_368_cov_0.932203_g10679_i0	PRJNA971593	10828	368	0.932203	3.43050704	Cloacibacterium	501783	Bacteria	Bacteria	680	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g10679	i0	100	500.73097826087	368	0	100	0	1	368	130033	129666	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	184269	680	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
11147867	11147867	PRJNA971593_P_NODE_23069_length_250_cov_0.870056_g22920_i0	PRJNA971593	23069	250	0.870056	2.17514	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g22920	i0	99.2	230.504	250	2	100	0	1	250	4833531	4833780	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	57626	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
11470064	11470064	PRJNA971593_P_NODE_14329_length_318_cov_0.979592_g14180_i0	PRJNA971593	14329	318	0.979592	3.11510256	Capnocytophaga	1016	Bacteria	Bacteria	106	2.26e-18	NTclustered	gi\|1242555297\|gb\|CP022382.1\|	28188	g14180	i0	80.556	5.95911949685535	144	22	44	6	176	316	802794	802654	Capnocytophaga canimorsus strain 7120 chromosome, complete genome	blastn	1895	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga canimorsus
16247054	16247054	PRJNA971593_P_NODE_19393_length_270_cov_1.340102_g19244_i0	PRJNA971593	19393	270	1.340102	3.6182754	Cloacibacterium caeni	2004710	Bacteria	Bacteria	475	1.2399999999999999e-129	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g19244	i0	98.519	4.6037037037037	270	3	100	1	1	270	678229	678497	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1243	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
17522497	17522497	PRJNA971593_P_NODE_8154_length_426_cov_1.155807_g8005_i0	PRJNA971593	8154	426	1.155807	4.92373782	Saprospira sp. CCB-QB6	3023936	Bacteria	Bacteria	451	3.47e-122	NTclustered	gi\|2440421932\|gb\|CP116808.1\|	3023936	g8005	i0	86.079	287.129107981221	431	46	100	14	4	426	1610928	1610504	Saprospira sp. CCB-QB6 chromosome, complete genome	blastn	122317	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira sp. CCB-QB6
18796195	18796195	PRJNA971593_P_NODE_5475_length_520_cov_2.807606_g5327_i0	PRJNA971593	5475	520	2.807606	14.5995512	uncultured Microscilla sp.	432653	Bacteria	Bacteria	592	2.4299999999999992e-164	NTclustered	gi\|192804281\|emb\|FM175083.1\|	432653	g5327	i0	94.103	79.225	390	21	75	2	1	389	389	1	Uncultured Microscilla sp. partial 16S rRNA gene, clone BF.S12	blastn	41197	592	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Microscillaceae	Microscilla	uncultured Microscilla sp.
22621366	22621366	PRJNA971593_P_NODE_21558_length_253_cov_2.033333_g21409_i0	PRJNA971593	21558	253	2.033333	5.14433249	Myroides odoratus	256	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2636494101\|gb\|CP139975.1\|	256	g21409	i0	100	0.221343873517787	28	0	11	0	199	226	489723	489696	Myroides odoratus strain HAMBI_1923 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratus
22621408	22621408	PRJNA971593_P_NODE_24598_length_248_cov_0.880000_g24449_i0	PRJNA971593	24598	248	0.88	2.1824	Emticicia oligotrophica	312279	Bacteria	Bacteria	215	2.7e-51	NTclustered	gi\|387853393\|gb\|CP002961.1\|	929562	g24449	i0	88.298	78.5483870967742	188	10	72	9	39	216	1412239	1412054	Emticicia oligotrophica DSM 17448, complete genome	blastn	19480	215	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
22944042	22944042	PRJNA971593_P_NODE_9338_length_397_cov_1.824074_g9189_i0	PRJNA971593	9338	397	1.824074	7.24157378	Cloacibacterium	501783	Bacteria	Bacteria	734	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g9189	i0	100	477.125944584383	397	0	100	0	1	397	2158270	2158666	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	189419	734	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
23896659	23896659	PRJNA971593_P_NODE_16259_length_296_cov_1.076233_g16110_i0	PRJNA971593	16259	296	1.076233	3.18564968	Runella rosea	2259595	Bacteria	Bacteria	514	2.92e-141	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g16110	i0	97.973	331.97972972973	296	6	100	0	1	296	4135899	4136194	Runella rosea strain HYN0085 chromosome, complete genome	blastn	98266	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea
23896908	23896908	PRJNA971593_P_NODE_6779_length_467_cov_1.814721_g6631_i0	PRJNA971593	6779	467	1.814721	8.47474707	Cloacibacterium caeni	2004710	Bacteria	Bacteria	832	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6631	i0	98.721	265.839400428266	469	4	100	2	1	467	1872095	1872563	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	124147	832	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
25492802	25492802	PRJNA971593_P_NODE_4020_length_602_cov_2.852552_g3876_i0	PRJNA971593	4020	602	2.852552	17.17236304	Cloacibacterium	501783	Bacteria	Bacteria	1112	0	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3876	i0	100	477.06976744186	602	0	100	0	1	602	130635	130034	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	287196	1112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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