metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA416866" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA416866" and tax_clade = "FCB group"

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
1083749	1083749	PRJNA416866_P_NODE_11661_length_201_cov_4.821429_g11517_i0	PRJNA416866	11661	201	4.821429	9.69107229	Bacteroidota	976	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2277262329\|gb\|OP060681.1\|	239	g11517	i0	100	104.980099502488	201	0	100	0	1	201	1007	1207	Flavobacterium sp. strain B1 16S ribosomal RNA gene, partial sequence	blastn	21101	372	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
1694499	1694499	PRJNA416866_P_NODE_9922_length_208_cov_0.870748_g9778_i0	PRJNA416866	9922	208	0.870748	1.81115584	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	337	4.49e-88	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g9778	i0	95.714	150.283653846154	210	7	100	2	1	208	787665	787456	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	31259	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
3634599	3634599	PRJNA416866_P_NODE_3763_length_342_cov_3.003559_g3620_i0	PRJNA416866	3763	342	3.003559	10.27217178	Bacteroidota	976	Bacteria	Bacteria	420	7.69e-113	NTclustered	gi\|470484653\|ref\|NR_076660.1\|	984	g3620	i0	89.552	307.289473684211	335	30	97	5	9	340	875	543	Pedobacter heparinus strain DSM 2366 23S ribosomal RNA gene, complete sequence	blastn	105093	424	0.990566037735849	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
7461683	7461683	PRJNA416866_P_NODE_10266_length_206_cov_1.765517_g10122_i0	PRJNA416866	10266	206	1.765517	3.63696502	Flectobacillus	101	Bacteria	Bacteria	377	2.62e-100	NTclustered	gi\|2868819032\|dbj\|LC855305.1\|	50419	g10122	i0	100	99.0145631067961	204	0	99	0	3	206	268	65	Flectobacillus sp. SLB19 gene for 16S rRNA, partial sequence	blastn	20397	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
8072994	8072994	PRJNA416866_P_NODE_9667_length_208_cov_2.333333_g9523_i0	PRJNA416866	9667	208	2.333333	4.85333264	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	324	3.5e-84	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g9523	i0	94.737	382.033653846154	209	10	100	1	1	208	360813	361021	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	79463	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
9347712	9347712	PRJNA416866_P_NODE_10568_length_205_cov_0.916667_g10424_i0	PRJNA416866	10568	205	0.916667	1.87916735	Pseudoprevotella muciniphila	2133944	Bacteria	Bacteria	252	1.64e-62	NTclustered	gi\|1765929929\|gb\|CP033459.1\|	2133944	g10424	i0	88.78	525.6	205	23	100	0	1	205	625107	624903	Pseudoprevotella muciniphila strain E39 chromosome, complete genome	blastn	107748	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Pseudoprevotella	Pseudoprevotella muciniphila
11287009	11287009	PRJNA416866_P_NODE_1349_length_607_cov_3.371795_g1210_i0	PRJNA416866	1349	607	3.371795	20.46679565	Chryseobacterium	59732	Bacteria	Bacteria	1072	0	NTclustered	gi\|1774322755\|gb\|CP045734.1\|	1813611	g1210	i0	98.52	495.827018121911	608	7	100	2	1	607	360279	359673	Chryseobacterium indologenes. StR 03 DNA, complete genome	blastn	300967	1072	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium cucumeris
14448560	14448560	PRJNA416866_P_NODE_9812_length_208_cov_0.870748_g9668_i0	PRJNA416866	9812	208	0.870748	1.81115584	Polaribacter sp. SA4-10	754397	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1199775334\|gb\|CP019331.1\|	754397	g9668	i0	100	0.134615384615385	28	0	13	0	159	186	936548	936575	Polaribacter sp. SA4-10 genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter sp. SA4-10
15722317	15722317	PRJNA416866_P_NODE_11973_length_200_cov_3.690647_g11829_i0	PRJNA416866	11973	200	3.690647	7.381294	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	215	2.09e-51	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g11829	i0	87.368	315.935	190	21	95	3	1	189	361293	361480	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	63187	215	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
16386192	16386192	PRJNA416866_P_NODE_1093_length_679_cov_3.226537_g957_i0	PRJNA416866	1093	679	3.226537	21.90818623	Flavobacterium	237	Bacteria	Bacteria	1210	0	NTclustered	gi\|2482065253\|gb\|CP121110.1\|	871694	g957	i0	98.824	526.215022091311	680	6	100	2	1	679	573238	572560	Flavobacterium ginsengisoli strain KCTC 23318 chromosome, complete genome	blastn	357300	1210	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ginsengisoli
16997065	16997065	PRJNA416866_P_NODE_294_length_1300_cov_6.508475_g228_i0	PRJNA416866	294	1300	6.508475	84.610175	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	1232	0	NTclustered	gi\|2556922676\|gb\|CP129488.1\|	2202734	g228	i0	84.012	388.774615384615	1326	166	99	37	3	1300	3060446	3059139	MAG: Saprospiraceae bacterium isolate cMAG.8 chromosome, complete genome	blastn	505407	1232	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
19545462	19545462	PRJNA416866_P_NODE_1216_length_642_cov_5.352840_g1078_i0	PRJNA416866	1216	642	5.35284	34.3652328	Tamlana crocina	393006	Bacteria	Bacteria	407	1.18e-108	NTclustered	gi\|2752113481\|gb\|CP158972.1\|	393006	g1078	i0	82.449	231.982866043614	490	63	74	21	165	642	3109229	3108751	Tamlana crocina strain HT-18 chromosome, complete genome	blastn	148933	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tamlana	Tamlana crocina
22096073	22096073	PRJNA416866_P_NODE_11758_length_201_cov_0.914286_g11614_i0	PRJNA416866	11758	201	0.914286	1.83771486	Chitinophaga sp. E66	2853437	Bacteria	Bacteria	165	2.15e-36	NTclustered	gi\|2070136974\|gb\|CP079103.1\|	2853437	g11614	i0	82.796	59.636815920398	186	31	92	1	17	201	222626	222441	Chitinophaga sp. E66 chromosome, complete genome	blastn	11987	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp. E66
22096076	22096076	PRJNA416866_P_NODE_12278_length_179_cov_4.050847_g12134_i0	PRJNA416866	12278	179	4.050847	7.25101613	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	303	3.79e-78	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g12134	i0	97.207	539.513966480447	179	5	100	0	1	179	444915	445093	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	96573	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
24646011	24646011	PRJNA416866_P_NODE_2460_length_436_cov_3.528000_g2317_i0	PRJNA416866	2460	436	3.528	15.38208	Reichenbachiella agarivorans	2979464	Bacteria	Bacteria	381	4.729999999999999e-101	NTclustered	gi\|2311319784\|gb\|CP106679.1\|	2979464	g2317	i0	82.766	528.754587155963	441	62	99	11	4	436	410396	410830	Reichenbachiella agarivorans strain BKB1-1 chromosome, complete genome	blastn	230537	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Reichenbachiella	Reichenbachiella agarivorans
24646040	24646040	PRJNA416866_P_NODE_7520_length_236_cov_1.200000_g7376_i0	PRJNA416866	7520	236	1.2	2.832	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	409	1.09e-109	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g7376	i0	97.89	362.60593220339	237	4	100	1	1	236	1744265	1744029	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	85575	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
24646054	24646054	PRJNA416866_P_NODE_9580_length_209_cov_0.864865_g9436_i0	PRJNA416866	9580	209	0.864865	1.80756785	Empedobacter falsenii	343874	Bacteria	Bacteria	342	9.709999999999999e-90	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g9436	i0	96.172	5.63636363636364	209	8	100	0	1	209	2980847	2980639	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	1178	342	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
25309916	25309916	PRJNA416866_P_NODE_8600_length_219_cov_4.208861_g8456_i0	PRJNA416866	8600	219	4.208861	9.21740559	Flavobacteriales	200644	Bacteria	Bacteria	377	2.81e-100	NTclustered	gi\|451917949\|gb\|KC451813.1\|	165435	g8456	i0	97.717	204.337899543379	219	5	100	0	1	219	3	221	Uncultured Flavobacterium sp. clone RLBp4862 16S ribosomal RNA gene, partial sequence	blastn	44750	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.

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