metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA557436" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA557436" 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
535643	535643	PRJNA557436_S_NODE_3201_length_217_cov_2.521978_g3153_i0	PRJNA557436	3201	217	2.521978	5.47269226	Prevotella dentalis	52227	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|433304126\|gb\|CP003370.1\|	908937	g3153	i0	100	38.8755760368664	217	0	100	0	1	217	2927	3143	Prevotella dentalis DSM 3688 plasmid pPREDE01, complete sequence	blastn	8436	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
535662	535662	PRJNA557436_S_NODE_721_length_418_cov_1.856397_g673_i0	PRJNA557436	721	418	1.856397	7.75973946	Prevotella dentalis	52227	Bacteria	Bacteria	773	0	NTclustered	gi\|433304126\|gb\|CP003370.1\|	908937	g673	i0	100	61.6698564593301	418	0	100	0	1	418	4081	4498	Prevotella dentalis DSM 3688 plasmid pPREDE01, complete sequence	blastn	25778	773	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
5639558	5639558	PRJNA557436_S_NODE_8945_length_153_cov_1.016949_g8897_i0	PRJNA557436	8945	153	1.016949	1.55593197	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	279	5.28e-71	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g8897	i0	100	0.986928104575163	151	0	99	0	1	151	1297136	1297286	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	151	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
8188585	8188585	PRJNA557436_S_NODE_5567_length_177_cov_2.056338_g5519_i0	PRJNA557436	5567	177	2.0563380000000002	3.63971826	Prevotella dentalis	52227	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|433304126\|gb\|CP003370.1\|	908937	g5519	i0	100	48.2598870056497	177	0	100	0	1	177	3533	3709	Prevotella dentalis DSM 3688 plasmid pPREDE01, complete sequence	blastn	8542	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
9464289	9464289	PRJNA557436_S_NODE_708_length_423_cov_2.309278_g660_i0	PRJNA557436	708	423	2.309278	9.76824594	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	355	2.77e-93	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g660	i0	82.009	423.914893617021	428	67	100	9	1	423	1237265	1236843	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	179316	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
10056821	10056821	PRJNA557436_S_NODE_808_length_396_cov_2.994460_g760_i0	PRJNA557436	808	396	2.99446	11.8580616	Prevotella	838	Bacteria	Bacteria	723	0	NTclustered	gi\|2028848006\|gb\|CP072343.1\|	28132	g760	i0	99.746	268.209595959596	394	1	99	0	3	396	383459	383852	Prevotella melaninogenica strain F0695 chromosome 1, complete sequence	blastn	106211	723	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10739823	10739823	PRJNA557436_S_NODE_3129_length_220_cov_1.329730_g3081_i0	PRJNA557436	3129	220	1.32973	2.925406	Prevotella dentalis	52227	Bacteria	Bacteria	401	1.6799999999999993e-107	NTclustered	gi\|433304126\|gb\|CP003370.1\|	908937	g3081	i0	99.545	33.8272727272727	220	1	100	0	1	220	3849	4068	Prevotella dentalis DSM 3688 plasmid pPREDE01, complete sequence	blastn	7442	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
12014640	12014640	PRJNA557436_S_NODE_1730_length_283_cov_2.205645_g1682_i0	PRJNA557436	1730	283	2.205645	6.24197535	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	440	4.769999999999998e-119	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g1682	i0	94.737	265.501766784452	285	11	100	3	1	283	2978299	2978017	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	75137	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
13289727	13289727	PRJNA557436_S_NODE_2311_length_249_cov_2.313084_g2263_i0	PRJNA557436	2311	249	2.313084	5.75957916	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	366	7.09e-97	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g2263	i0	93.173	555.265060240964	249	17	100	0	1	249	1234476	1234724	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	138261	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
13289729	13289729	PRJNA557436_S_NODE_3231_length_216_cov_3.259669_g3183_i0	PRJNA557436	3231	216	3.259669	7.04088504	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	351	1.68e-92	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g3183	i0	97.115	282.148148148148	208	6	96	0	1	208	2980198	2980405	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	60944	351	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
15838466	15838466	PRJNA557436_S_NODE_2293_length_250_cov_1.897674_g2245_i0	PRJNA557436	2293	250	1.897674	4.744185	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g2245	i0	93.2	240.256	250	17	100	0	1	250	2977856	2977607	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	60064	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
16431012	16431012	PRJNA557436_S_NODE_4533_length_190_cov_4.632258_g4485_i0	PRJNA557436	4533	190	4.632258	8.8012902	Prevotella	838	Bacteria	Bacteria	350	5.169999999999999e-92	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g4485	i0	100	260.631578947368	189	0	99	0	2	190	699860	700048	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	49520	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
16431015	16431015	PRJNA557436_S_NODE_53_length_1445_cov_5.551773_g42_i0	PRJNA557436	53	1445	5.551773	80.22311985	Prevotella	838	Bacteria	Bacteria	2645	0	NTclustered	gi\|2127645162\|gb\|CP085940.1\|	28132	g42	i0	99.861	238.882352941176	1438	2	99	0	8	1445	1853957	1852520	Prevotella melaninogenica strain FDAARGOS_1567 chromosome 1, complete sequence	blastn	345185	2645	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
20937752	20937752	PRJNA557436_S_NODE_6037_length_172_cov_2.569343_g5989_i0	PRJNA557436	6037	172	2.569343	4.41926996	Prevotella dentalis	52227	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|433304126\|gb\|CP003370.1\|	908937	g5989	i0	100	2.00581395348837	172	0	100	0	1	172	2107	1936	Prevotella dentalis DSM 3688 plasmid pPREDE01, complete sequence	blastn	345	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella dentalis
21530290	21530290	PRJNA557436_S_NODE_2637_length_234_cov_3.492462_g2589_i0	PRJNA557436	2637	234	3.492462	8.17236108	Sediminibacterium	504481	Bacteria	Bacteria	407	3.88e-109	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g2589	i0	100	255.252136752137	220	0	94	0	1	220	55161	54942	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	59729	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
24761924	24761924	PRJNA557436_S_NODE_7000_length_164_cov_2.038760_g6952_i0	PRJNA557436	7000	164	2.03876	3.3435664	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	265	1.6199999999999998e-66	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g6952	i0	95.758	228.274390243902	165	5	100	2	1	164	2978438	2978275	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	37437	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17

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