metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA934332" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA934332" 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
1255419	1255419	PRJNA934332_P_NODE_11381_length_241_cov_0.916667_g11294_i0	PRJNA934332	11381	241	0.916667	2.20916747	Porphyromonas	836	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1274923455\|gb\|CP024600.1\|	837	g11294	i0	99.585	35	241	1	100	0	1	241	759682	759922	Porphyromonas gingivalis strain KCOM 2801 chromosome, complete genome	blastn	8435	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
2185922	2185922	PRJNA934332_P_NODE_11082_length_241_cov_1.375000_g10995_i0	PRJNA934332	11082	241	1.375	3.31375	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	198	2.63e-46	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g10995	i0	82.174	18.9709543568465	230	41	95	0	5	234	2817293	2817522	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	4572	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
3461473	3461473	PRJNA934332_P_NODE_11023_length_242_cov_0.911243_g10936_i0	PRJNA934332	11023	242	0.911243	2.20520806	Flavobacteriaceae bacterium UJ101	1150389	Bacteria	Bacteria	165	2.68e-36	NTclustered	gi\|1102952253\|gb\|CP016269.1\|	1150389	g10936	i0	79.325	18.0371900826446	237	47	98	2	6	241	647016	647251	Flavobacteriaceae bacterium UJ101 chromosome, complete genome	blastn	4365	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium UJ101
5083756	5083756	PRJNA934332_P_NODE_4804_length_302_cov_1.244541_g4717_i0	PRJNA934332	4804	302	1.244541	3.75851382	Porphyromonas	836	Bacteria	Bacteria	547	2.9399999999999987e-151	NTclustered	gi\|532498\|dbj\|D17342.1\|BNRGROES	837	g4717	i0	99.338	40.2450331125828	302	2	100	0	1	302	2441	2140	Porphyromonas gingivalis genes for GroEL, GroES, complete cds	blastn	12154	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
6013899	6013899	PRJNA934332_P_NODE_8825_length_248_cov_0.880000_g8738_i0	PRJNA934332	8825	248	0.88	2.1824	Prevotella corporis	28128	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2446185766\|gb\|CP118020.1\|	28128	g8738	i0	99.597	205.012096774194	248	1	100	0	1	248	1287771	1288018	Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence	blastn	50843	453	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis
7288720	7288720	PRJNA934332_P_NODE_2526_length_392_cov_1.351097_g2439_i0	PRJNA934332	2526	392	1.351097	5.29630024	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	686	0	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g2439	i0	98.219	285.928571428571	393	6	100	1	1	392	3293845	3293453	Lacibacter sp. MH-610 chromosome	blastn	112084	686	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
7633548	7633548	PRJNA934332_P_NODE_2486_length_395_cov_1.673913_g2399_i0	PRJNA934332	2486	395	1.673913	6.61195635	Porphyromonas	836	Bacteria	Bacteria	730	0	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g2399	i0	100	17	395	0	100	0	1	395	744921	744527	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	6715	730	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
8563603	8563603	PRJNA934332_P_NODE_6707_length_265_cov_1.286458_g6620_i0	PRJNA934332	6707	265	1.286458	3.4091137	Flavobacterium nakdongensis	3073563	Bacteria	Bacteria	276	1.32e-69	NTclustered	gi\|2575681008\|gb\|CP133721.1\|	3073563	g6620	i0	85.769	48.3207547169811	260	37	98	0	1	260	103447	103706	Flavobacterium nakdongensis strain 20NA77.7 chromosome, complete genome	blastn	12805	276	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nakdongensis
9838578	9838578	PRJNA934332_P_NODE_1888_length_444_cov_1.029650_g1801_i0	PRJNA934332	1888	444	1.02965	4.571646	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	658	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g1801	i0	93.512	233.074324324324	447	21	100	8	1	444	2978309	2977868	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	103485	658	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
10184116	10184116	PRJNA934332_P_NODE_7128_length_257_cov_1.396739_g7041_i0	PRJNA934332	7128	257	1.396739	3.58961923	Phocaeicola	909656	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1840190378\|gb\|CP046425.1\|	357276	g7041	i0	100	34	257	0	100	0	1	257	4536865	4537121	Phocaeicola dorei strain JR02 chromosome, complete genome	blastn	8738	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola dorei
11459177	11459177	PRJNA934332_P_NODE_11009_length_242_cov_0.911243_g10922_i0	PRJNA934332	11009	242	0.911243	2.20520806	Porphyromonas	836	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2437755982\|gb\|CP116614.1\|	837	g10922	i0	100	36.3512396694215	242	0	100	0	1	242	1231793	1232034	Porphyromonas gingivalis strain ATCC 49417 chromosome, complete genome	blastn	8797	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
11459210	11459210	PRJNA934332_P_NODE_9949_length_245_cov_0.895349_g9862_i0	PRJNA934332	9949	245	0.895349	2.19360505	Weeksellaceae	2762318	Bacteria	Bacteria	359	1.16e-94	NTclustered	gi\|1527179843\|gb\|CP034173.1\|	536441	g9862	i0	93.724	98.330612244898	239	15	98	0	5	243	534803	534565	Chryseobacterium taklimakanense strain F9257 chromosome, complete genome	blastn	24091	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
12389758	12389758	PRJNA934332_P_NODE_3030_length_365_cov_1.054795_g2943_i0	PRJNA934332	3030	365	1.054795	3.85000175	Candidatus Amoebophilus asiaticus	281120	Bacteria	Bacteria	542	1.69e-149	NTclustered	gi\|189496911\|gb\|CP001102.1\|	452471	g2943	i0	93.425	80.641095890411	365	24	100	0	1	365	596844	596480	Candidatus Amoebophilus asiaticus 5a2, complete genome	blastn	29434	542	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Amoebophilaceae	Candidatus Amoebophilus	Candidatus Amoebophilus asiaticus
12389775	12389775	PRJNA934332_P_NODE_4830_length_301_cov_1.653509_g4743_i0	PRJNA934332	4830	301	1.653509	4.97706209	Prevotella corporis	28128	Bacteria	Bacteria	549	8.149999999999997e-152	NTclustered	gi\|2446185766\|gb\|CP118020.1\|	28128	g4743	i0	99.667	234.813953488372	300	1	99	0	1	300	1695552	1695851	Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence	blastn	70679	549	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis
12389806	12389806	PRJNA934332_P_NODE_7930_length_250_cov_0.870056_g7843_i0	PRJNA934332	7930	250	0.870056	2.17514	Bacteroidales bacterium	2030927	Bacteria	Bacteria	368	1.98e-97	NTclustered	gi\|2621786219\|emb\|OY782677.1\|	2030927	g7843	i0	96.413	303.396	223	8	89	0	28	250	2216615	2216393	MAG: Bacteroidales bacterium isolate 20de20eb-1543-480f-a7de-dbc982fee115 genome assembly, chromosome: 1	blastn	75849	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
12734835	12734835	PRJNA934332_P_NODE_10970_length_242_cov_0.911243_g10883_i0	PRJNA934332	10970	242	0.911243	2.20520806	Prevotella	838	Bacteria	Bacteria	337	5.37e-88	NTclustered	gi\|2774256485\|dbj\|AP035785.1\|	3236793	g10883	i0	91.736	251.396694214876	242	20	100	0	1	242	948746	948505	Prevotella sp. GTC17253 DNA, complete genome	blastn	60838	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. GTC17253
14009419	14009419	PRJNA934332_P_NODE_10171_length_244_cov_0.900585_g10084_i0	PRJNA934332	10171	244	0.900585	2.1974274	Porphyromonas	836	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|188593544\|dbj\|AP009380.1\|	431947	g10084	i0	100	34.7909836065574	244	0	100	0	1	244	434124	433881	Porphyromonas gingivalis ATCC 33277 DNA, complete genome	blastn	8489	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
14938539	14938539	PRJNA934332_P_NODE_7012_length_259_cov_1.655914_g6925_i0	PRJNA934332	7012	259	1.655914	4.28881726	Flavobacterium sp.	239	Bacteria	Bacteria	473	4.25e-129	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g6925	i0	99.615	710.471042471042	260	0	100	1	1	259	236673	236932	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	184012	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
20037279	20037279	PRJNA934332_P_NODE_7216_length_256_cov_0.879781_g7129_i0	PRJNA934332	7216	256	0.879781	2.25223936	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	143	1.34e-29	NTclustered	gi\|2874253929\|emb\|OY970254.1\|	866510	g7129	i0	82.036	0.65234375	167	30	65	0	43	209	4558554	4558388	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.1.55 genome assembly, chromosome: 1	blastn	167	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
20381726	20381726	PRJNA934332_P_NODE_1996_length_433_cov_2.708333_g1909_i0	PRJNA934332	1996	433	2.708333	11.72708189	Sediminibacterium	504481	Bacteria	Bacteria	776	0	NTclustered	gi\|2285221741\|dbj\|AP026683.1\|	575378	g1909	i0	99.531	238.956120092379	426	2	98	0	8	433	55220	54795	Sediminibacterium sp. TEGAF015 DNA, complete genome	blastn	103468	778	0.997429305912596	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. TEGAF015
21312740	21312740	PRJNA934332_P_NODE_9977_length_245_cov_0.872093_g9890_i0	PRJNA934332	9977	245	0.872093	2.13662785	Prevotella intermedia	28131	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|965692493\|dbj\|AP014597.1\|	28131	g9890	i0	99.59	31.0122448979592	244	1	99	0	2	245	1830717	1830474	Prevotella intermedia DNA, complete genome, strain: OMA14, chromosome: I	blastn	7598	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
23863022	23863022	PRJNA934332_P_NODE_9859_length_245_cov_0.895349_g9772_i0	PRJNA934332	9859	245	0.895349	2.19360505	Haliscomenobacter hydrossis	2350	Bacteria	Bacteria	147	9.86e-31	NTclustered	gi\|332330813\|gb\|CP002691.1\|	760192	g9772	i0	88.095	0.751020408163265	126	11	51	4	1	126	2194813	2194692	Haliscomenobacter hydrossis DSM 1100 chromosome, complete genome	blastn	184	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
25136799	25136799	PRJNA934332_P_NODE_7080_length_258_cov_1.562162_g6993_i0	PRJNA934332	7080	258	1.562162	4.03037796	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g6993	i0	99.225	2	258	2	100	0	1	258	378960	379217	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	516	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
25136819	25136819	PRJNA934332_P_NODE_9480_length_246_cov_0.890173_g9393_i0	PRJNA934332	9480	246	0.890173	2.18982558	Prevotella melaninogenica	28132	Bacteria	Bacteria	311	3.32e-80	NTclustered	gi\|2028849345\|gb\|CP072344.1\|	28132	g9393	i0	89.431	11.9186991869919	246	26	100	0	1	246	856570	856815	Prevotella melaninogenica strain F0695 chromosome 2, complete sequence	blastn	2932	311	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
25482012	25482012	PRJNA934332_P_NODE_9140_length_247_cov_0.885057_g9053_i0	PRJNA934332	9140	247	0.885057	2.18609079	Flectobacillus	101	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1717508336\|gb\|MN258894.1\|	502259	g9053	i0	99.595	99.9757085020243	247	1	100	0	1	247	4	250	Flectobacillus roseus strain PeD7 16S ribosomal RNA gene, partial sequence	blastn	24694	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus roseus

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