metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA702290" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA702290" 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
1184670	1184670	PRJNA702290_P_NODE_41_length_534_cov_14.448485_g34_i0	PRJNA702290	41	534	14.448485	77.1549099	Weeksellaceae	2762318	Bacteria	Bacteria	283	1.71e-71	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g34	i0	99.359	313.975655430712	156	1	85	0	280	435	2627763	2627918	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	167663	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
3234758	3234758	PRJNA702290_P_NODE_1123_length_191_cov_4.914474_g1115_i0	PRJNA702290	1123	191	4.914474	9.38664534	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	128	2.65e-25	NTclustered	gi\|1958116195\|gb\|CP065012.1\|	1869212	g1115	i0	98.63	84.2251308900524	73	0	75	1	6	78	2394532	2394603	MAG: Chitinophagaceae bacterium isolate Rand_18-Q3-R56-63_BAT3C.147_cln chromosome, complete genome	blastn	16087	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
5012941	5012941	PRJNA702290_P_NODE_1824_length_156_cov_23.606838_g1816_i0	PRJNA702290	1824	156	23.606838	36.82666728	Porphyromonas	836	Bacteria	Bacteria	141	2.67e-29	NTclustered	gi\|470488515\|ref\|NR_076875.1\|	28123	g1816	i0	100	348.294871794872	76	0	97	0	3	78	849	774	Porphyromonas asaccharolytica strain DSM 20707 23S ribosomal RNA gene, complete sequence	blastn	54334	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas asaccharolytica
5787299	5787299	PRJNA702290_P_NODE_505_length_200_cov_13.378882_g497_i0	PRJNA702290	505	200	13.378882	26.757764	Riemerella columbina	103810	Bacteria	Bacteria	171	4.599999999999999e-38	NTclustered	gi\|2550510927\|gb\|CP103950.1\|	103810	g497	i0	90.698	491.385	129	10	64	2	2	129	2510	2383	Riemerella columbina strain TH22 chromosome, complete genome	blastn	98277	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Riemerella	Riemerella columbina
6288702	6288702	PRJNA702290_P_NODE_625_length_191_cov_19.526316_g617_i0	PRJNA702290	625	191	19.526316	37.29526356	Hymenobacteraceae	1853232	Bacteria	Bacteria	139	1.23e-28	NTclustered	gi\|937827812\|gb\|CP012643.1\|	512763	g617	i0	98.718	166.926701570681	78	1	41	0	111	188	460680	460603	Rufibacter tibetensis strain 1351, complete genome	blastn	31883	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Rufibacter	Rufibacter tibetensis
8336935	8336935	PRJNA702290_P_NODE_527_length_196_cov_36.694268_g519_i0	PRJNA702290	527	196	36.694268	71.92076528	Chryseobacterium oryzae	2929799	Bacteria	Bacteria	315	1.9599999999999999e-81	NTclustered	gi\|2216362202\|gb\|CP094529.1\|	2929799	g519	i0	97.312	435.663265306122	186	4	95	1	4	189	222849	222665	Chryseobacterium oryzae strain ADR-1 chromosome, complete genome	blastn	85390	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium oryzae
9612255	9612255	PRJNA702290_P_NODE_1248_length_190_cov_22.761589_g1240_i0	PRJNA702290	1248	190	22.761589	43.2470191	Hymenobacter sp. PAMC 26628	1484118	Bacteria	Bacteria	99	2.07e-16	NTclustered	gi\|996006667\|gb\|CP014304.1\|	1484118	g1240	i0	90.667	1.16315789473684	75	5	39	2	112	185	4950480	4950407	Hymenobacter sp. PAMC 26628 chromosome, complete genome	blastn	221	99	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. PAMC 26628
10113254	10113254	PRJNA702290_P_NODE_1668_length_158_cov_12.529412_g1660_i0	PRJNA702290	1668	158	12.529412	19.79647096	Hymenobacter	89966	Bacteria	Bacteria	139	9.74e-29	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g1660	i0	98.718	171.911392405063	78	1	49	0	78	155	1424910	1424987	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	27162	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
10113277	10113277	PRJNA702290_P_NODE_728_length_191_cov_14.776316_g720_i0	PRJNA702290	728	191	14.776316	28.22276356	Flavobacterium	237	Bacteria	Bacteria	198	1.99e-46	NTclustered	gi\|2206042033\|gb\|CP092832.1\|	1160795	g720	i0	99.091	455.052356020942	110	1	91	0	1	110	1451661	1451770	Flavobacterium sp. HJ-32-4 chromosome, complete genome	blastn	86915	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. HJ-32-4
10887872	10887872	PRJNA702290_P_NODE_809_length_191_cov_12.552632_g801_i0	PRJNA702290	809	191	12.552632	23.97552712	Porphyromonas asaccharolytica	28123	Bacteria	Bacteria	135	1.59e-27	NTclustered	gi\|332176264\|gb\|CP002689.1\|	879243	g801	i0	98.684	0.81151832460733	76	1	81	0	114	189	2174372	2174447	Porphyromonas asaccharolytica DSM 20707, complete genome	blastn	155	135	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas asaccharolytica
11388247	11388247	PRJNA702290_P_NODE_1949_length_155_cov_8.905172_g1941_i0	PRJNA702290	1949	155	8.905172	13.8030166	Flavobacteriales	200644	Bacteria	Bacteria	139	9.51e-29	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g1941	i0	98.718	77.8709677419355	78	1	50	0	3	80	227635	227712	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	12070	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
12664147	12664147	PRJNA702290_P_NODE_330_length_250_cov_26.597156_g322_i0	PRJNA702290	330	250	26.597156	66.49289	Hymenobacter	89966	Bacteria	Bacteria	267	7.43e-67	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g322	i0	98.039	179.196	153	3	90	0	96	248	1424371	1424219	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	44799	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
13938569	13938569	PRJNA702290_P_NODE_1491_length_160_cov_19.958678_g1483_i0	PRJNA702290	1491	160	19.958678	31.9338848	Sphingobacterium	28453	Bacteria	Bacteria	176	7.55e-40	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g1483	i0	87.209	332.26875	172	0	94	1	4	153	1767092	1767263	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	53163	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
14712759	14712759	PRJNA702290_P_NODE_1532_length_159_cov_17.275000_g1524_i0	PRJNA702290	1532	159	17.275	27.46725	Hymenobacter jejuensis	2502781	Bacteria	Bacteria	259	7.23e-65	NTclustered	gi\|1682022672\|gb\|CP040896.1\|	2502781	g1524	i0	97.987	265.654088050314	149	3	96	0	7	155	25151	25299	Hymenobacter jejuensis strain 17J68-5 chromosome, complete genome	blastn	42239	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter jejuensis
16487599	16487599	PRJNA702290_P_NODE_1533_length_159_cov_17.125000_g1525_i0	PRJNA702290	1533	159	17.125	27.22875	Prevotella	838	Bacteria	Bacteria	134	4.5700000000000005e-27	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g1525	i0	97.436	176.396226415094	78	2	96	0	80	157	697997	698074	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	28047	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
17261694	17261694	PRJNA702290_P_NODE_1014_length_191_cov_8.111842_g1006_i0	PRJNA702290	1014	191	8.111842	15.49361822	Ferruginibacter lapsinanis	563172	Bacteria	Bacteria	139	1.23e-28	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g1006	i0	98.718	95.4031413612565	78	1	41	0	112	189	1662538	1662615	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	18222	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
19036428	19036428	PRJNA702290_P_NODE_935_length_191_cov_9.736842_g927_i0	PRJNA702290	935	191	9.736842	18.59736822	Prevotella	838	Bacteria	Bacteria	139	1.23e-28	NTclustered	gi\|2028834046\|gb\|CP072331.1\|	28137	g927	i0	98.718	211.858638743455	78	1	81	0	1	78	204157	204234	Prevotella veroralis strain F0319 chromosome 2, complete sequence	blastn	40465	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella veroralis
20311024	20311024	PRJNA702290_P_NODE_996_length_191_cov_8.500000_g988_i0	PRJNA702290	996	191	8.5	16.235	Alloprevotella	1283313	Bacteria	Bacteria	147	7.329999999999999e-31	NTclustered	gi\|285171239\|gb\|GU413091.1\|	76122	g988	i0	100	80.2513089005236	79	0	81	0	112	190	244	322	Prevotella tannerae clone TU014 16S ribosomal RNA gene, partial sequence	blastn	15328	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella tannerae
21586886	21586886	PRJNA702290_P_NODE_1497_length_160_cov_15.595041_g1489_i0	PRJNA702290	1497	160	15.595041	24.9520656	Weeksellaceae	2762318	Bacteria	Bacteria	263	5.629999999999999e-66	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g1489	i0	98.013	417.0875	151	3	94	0	2	152	1987892	1988042	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	66734	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
22862133	22862133	PRJNA702290_P_NODE_758_length_191_cov_13.828947_g750_i0	PRJNA702290	758	191	13.828947	26.41328877	Sphingobacteriaceae	84566	Bacteria	Bacteria	141	3.41e-29	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g750	i0	100	274.905759162304	76	0	81	0	4	79	1278860	1278785	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	52507	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii

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