metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB43370" 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
60185	60185	PRJEB43370_P_NODE_1801_length_325_cov_1.865942_g1758_i0	PRJEB43370	1801	325	1.865942	6.0643115	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	418	2.6099999999999995e-112	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g1758	i0	89.908	386.636923076923	327	29	100	4	1	325	2012372	2012048	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	125657	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
60211	60211	PRJEB43370_P_NODE_381_length_679_cov_1.476190_g341_i0	PRJEB43370	381	679	1.47619	10.0233301	Aureispira anguillae	2864201	Bacteria	Bacteria	510	9.29e-140	NTclustered	gi\|2314744358\|dbj\|AP026867.1\|	2864201	g341	i0	80.808	383.787923416789	693	98	99	28	3	679	4696274	4696947	Aureispira anguillae EL160426 DNA, complete genome	blastn	260592	510	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Aureispira	Aureispira anguillae
2610146	2610146	PRJEB43370_P_NODE_6283_length_183_cov_1.432836_g6240_i0	PRJEB43370	6283	183	1.432836	2.62208988	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	143	8.989999999999998e-30	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g6240	i0	85.401	10.2786885245902	137	20	75	0	1	137	4997233	4997097	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	1881	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
3886317	3886317	PRJEB43370_P_NODE_44_length_1638_cov_3.117055_g35_i0	PRJEB43370	44	1638	3.117055	51.0573609	Fulvivirga maritima	2904247	Bacteria	Bacteria	1288	0	NTclustered	gi\|2174443093\|gb\|CP089980.1\|	2904247	g35	i0	81.216	407.053113553114	1661	256	99	47	8	1636	242581	244217	Fulvivirga maritima strain SW1-E11 chromosome, complete genome	blastn	666753	1288	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga maritima
5162498	5162498	PRJEB43370_P_NODE_2185_length_293_cov_2.331967_g2142_i0	PRJEB43370	2185	293	2.331967	6.83266331	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	420	6.469999999999998e-113	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g2142	i0	92.491	376.648464163823	293	22	100	0	1	293	2012469	2012761	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	110358	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
5162514	5162514	PRJEB43370_P_NODE_3325_length_240_cov_1.089005_g3282_i0	PRJEB43370	3325	240	1.089005	2.613612	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	134	7.49e-27	NTclustered	gi\|2621703510\|emb\|OY762557.1\|	2910168	g3282	i0	81.875	27.6875	160	27	66	2	80	238	547794	547952	MAG: Longimicrobiales bacterium isolate c10e2151-7d97-4465-9cf7-a78a4796a63d genome assembly, chromosome: 1	blastn	6645	134	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
6438378	6438378	PRJEB43370_P_NODE_6926_length_174_cov_1.632000_g6883_i0	PRJEB43370	6926	174	1.632	2.83968	uncultured Draconibacterium sp.	1573823	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2621785580\|emb\|OY782038.1\|	1573823	g6883	i0	100	0.160919540229885	28	0	16	0	126	153	5166197	5166224	MAG: uncultured Draconibacterium sp. isolate bcad0d1a-6e49-421f-8d27-4f0c578a9024 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Draconibacterium	uncultured Draconibacterium sp.
7712550	7712550	PRJEB43370_P_NODE_1087_length_417_cov_2.220109_g1044_i0	PRJEB43370	1087	417	2.220109	9.25785453	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	525	1.9699999999999994e-144	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g1044	i0	89.474	298.611510791367	418	40	99	4	2	416	2013359	2012943	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	124521	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
8987323	8987323	PRJEB43370_P_NODE_3748_length_228_cov_1.011173_g3705_i0	PRJEB43370	3748	228	1.011173	2.30547444	Parabacteroides goldsteinii	328812	Bacteria	Bacteria	324	3.8999999999999998e-84	NTclustered	gi\|2777523482\|dbj\|AP031410.1\|	328812	g3705	i0	92.478	484.478070175439	226	17	99	0	3	228	182395	182170	Parabacteroides goldsteinii f09 DNA, complete genome	blastn	110461	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
9918117	9918117	PRJEB43370_P_NODE_3488_length_234_cov_6.497297_g3445_i0	PRJEB43370	3488	234	6.497297	15.20367498	Bacteroidota	976	Bacteria	Bacteria	226	1.1699999999999999e-54	NTclustered	gi\|1986777041\|gb\|CP056775.1\|	2747268	g3445	i0	84.583	253.179487179487	240	23	100	12	1	234	868312	868081	Dyadobacter sandarakinus strain Q3-56 chromosome, complete genome	blastn	59244	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sandarakinus
11538457	11538457	PRJEB43370_P_NODE_9590_length_165_cov_0.896552_g9547_i0	PRJEB43370	9590	165	0.896552	1.4793108	Faecalibacter bovis	2898187	Bacteria	Bacteria	67.6	4.93e-7	NTclustered	gi\|2025704867\|gb\|CP072842.1\|	2898187	g9547	i0	90.196	0.309090909090909	51	5	31	0	78	128	771420	771470	Faecalibacter bovis strain ZY171143 chromosome, complete genome	blastn	51	67.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Faecalibacter	Faecalibacter bovis
12469000	12469000	PRJEB43370_P_NODE_3010_length_250_cov_1.815920_g2967_i0	PRJEB43370	3010	250	1.81592	4.5398	Bacteroidota	976	Bacteria	Bacteria	278	3.43e-70	NTclustered	gi\|507148306\|ref\|NR_103109.1\|	232259	g2967	i0	86.853	243.112	251	29	99	2	1	249	1010	762	Belliella baltica strain BA134 23S ribosomal RNA gene, complete sequence	blastn	60778	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Belliella	Belliella baltica
12813689	12813689	PRJEB43370_P_NODE_1431_length_363_cov_2.506369_g1388_i0	PRJEB43370	1431	363	2.506369	9.09811947	Saprospira sp. CCB-QB6	3023936	Bacteria	Bacteria	409	1.7699999999999997e-109	NTclustered	gi\|2440421932\|gb\|CP116808.1\|	3023936	g1388	i0	87.671	295.573002754821	365	27	98	16	1	356	1610884	1610529	Saprospira sp. CCB-QB6 chromosome, complete genome	blastn	107293	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Saprospira	Saprospira sp. CCB-QB6
15017764	15017764	PRJEB43370_P_NODE_4912_length_204_cov_1.006452_g4869_i0	PRJEB43370	4912	204	1.006452	2.05316208	Bacteroides	816	Bacteria	Bacteria	268	1.6199999999999998e-67	NTclustered	gi\|2093932526\|gb\|CP082886.1\|	291645	g4869	i0	91.327	455.210784313725	196	17	98	0	4	199	1481858	1481663	Bacteroides nordii strain FDAARGOS_1461 chromosome, complete genome	blastn	92863	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides nordii
15362400	15362400	PRJEB43370_P_NODE_3633_length_230_cov_2.011050_g3590_i0	PRJEB43370	3633	230	2.01105	4.625415	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	424	3.78e-114	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g3590	i0	100	656.117391304348	229	0	99	0	1	229	981910	982138	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	150907	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
15362420	15362420	PRJEB43370_P_NODE_6013_length_186_cov_2.277372_g5970_i0	PRJEB43370	6013	186	2.277372	4.23591192	Flavobacterium channae	2897181	Bacteria	Bacteria	329	6.56e-86	NTclustered	gi\|2164478757\|gb\|CP089096.1\|	2897181	g5970	i0	98.404	453.39247311828	188	1	100	2	1	186	485991	485804	Flavobacterium channae strain KSM-R2A30 chromosome, complete genome	blastn	84331	329	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium channae
16637014	16637014	PRJEB43370_P_NODE_5894_length_188_cov_1.496403_g5851_i0	PRJEB43370	5894	188	1.496403	2.81323764	Cellulophaga sp. TSM-5	3393396	Bacteria	Bacteria	60.2	9.63e-5	NTclustered	gi\|2900105490\|dbj\|AP039451.1\|	3393396	g5851	i0	83.077	0.345744680851064	65	11	35	0	101	165	2891982	2891918	Cellulophaga sp. TSM-5 DNA, complete genome	blastn	65	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. TSM-5
17567741	17567741	PRJEB43370_P_NODE_3854_length_225_cov_1.772727_g3811_i0	PRJEB43370	3854	225	1.772727	3.98863575	Cytophagales	768507	Bacteria	Bacteria	182	2.45e-41	NTclustered	gi\|2075689917\|gb\|CP048415.1\|	2705473	g3811	i0	81.333	294.946666666667	225	40	100	2	1	225	37086	37308	Algoriphagus sp. NBT04N3 chromosome, complete genome	blastn	66363	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp. NBT04N3
19185725	19185725	PRJEB43370_P_NODE_6536_length_179_cov_2.276923_g6493_i0	PRJEB43370	6536	179	2.276923	4.07569217	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	309	8.15e-80	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g6493	i0	97.765	395	179	4	100	0	1	179	2013830	2014008	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	70705	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris
19185747	19185747	PRJEB43370_P_NODE_8816_length_166_cov_0.888889_g8773_i0	PRJEB43370	8816	166	0.888889	1.47555574	Bacteroidota bacterium	1898104	Bacteria	Bacteria	198	1.69e-46	NTclustered	gi\|1958103773\|gb\|CP065006.1\|	1898104	g8773	i0	88.623	259.403614457831	167	14	99	5	1	164	2431721	2431885	Bacteroidetes bacterium isolate Lyne_18-Q3-R50-59_BAT3C.262 chromosome	blastn	43061	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
24285996	24285996	PRJEB43370_P_NODE_3100_length_247_cov_1.575758_g3057_i0	PRJEB43370	3100	247	1.575758	3.89212226	Pontibacter actiniarum	323450	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|1194998661\|gb\|CP021235.1\|	323450	g3057	i0	86.792	218.923076923077	212	22	88	4	7	217	347166	347372	Pontibacter actiniarum strain DSM 19842 chromosome, complete genome	blastn	54074	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter actiniarum

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