metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA885753" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA885753" 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
2516922	2516922	PRJNA885753_S_NODE_2082_length_312_cov_1.631799_g2064_i0	PRJNA885753	2082	312	1.631799	5.09121288	Flectobacillus	101	Bacteria	Bacteria	571	1.81e-158	NTclustered	gi\|4127845\|emb\|AJ011917.1\|	50419	g2064	i0	99.679	101.580128205128	312	1	100	0	1	312	1141	1452	Flectobacillus sp. 16S rRNA gene, partial, strain MWH38	blastn	31693	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
3412508	3412508	PRJNA885753_S_NODE_3863_length_250_cov_0.881356_g3845_i0	PRJNA885753	3863	250	0.881356	2.20339	Petrimonas mucosa	1642646	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|1088721598\|emb\|LT608328.1\|	1642646	g3845	i0	99.2	8.04	250	2	100	0	1	250	756033	755784	Petrimonas mucosa isolate ING2-E5A genome assembly, chromosome: I	blastn	2010	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas mucosa
3412511	3412511	PRJNA885753_S_NODE_3983_length_249_cov_0.869318_g3965_i0	PRJNA885753	3983	249	0.869318	2.16460182	Xiashengella succiniciproducens	2949635	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|2250061814\|gb\|CP098400.1\|	2949635	g3965	i0	97.992	1	249	5	100	0	1	249	878971	878723	Xiashengella succiniciproducens strain Ai-910 chromosome, complete genome	blastn	249	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Xiashengella	Xiashengella succiniciproducens
4690119	4690119	PRJNA885753_S_NODE_1884_length_325_cov_1.777778_g1866_i0	PRJNA885753	1884	325	1.777778	5.7777785	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	427	4.339999999999999e-115	NTclustered	gi\|2179090906\|gb\|CP090557.1\|	2907205	g1866	i0	92.131	243.926153846154	305	21	94	3	21	325	418468	418167	Tellurirhabdus bombi strain IE-0392 chromosome, complete genome	blastn	79276	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
16164483	16164483	PRJNA885753_S_NODE_4493_length_243_cov_0.917647_g4475_i0	PRJNA885753	4493	243	0.917647	2.22988221	Fermentimonas caenicola	1562970	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4475	i0	100	1	243	0	100	0	1	243	990705	990463	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	243	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
17439907	17439907	PRJNA885753_S_NODE_3494_length_256_cov_1.251366_g3476_i0	PRJNA885753	3494	256	1.251366	3.20349696	Spirosoma linguale	108	Bacteria	Bacteria	272	1.64e-68	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g3476	i0	85.985	233.72265625	264	26	99	11	2	256	6730079	6729818	Spirosoma linguale DSM 74, complete genome	blastn	59833	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
18713126	18713126	PRJNA885753_S_NODE_3695_length_252_cov_0.871508_g3677_i0	PRJNA885753	3695	252	0.871508	2.19620016	Fermentimonas caenicola	1562970	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g3677	i0	100	1	252	0	100	0	1	252	43786	44037	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	252	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
18713128	18713128	PRJNA885753_S_NODE_3875_length_250_cov_0.881356_g3857_i0	PRJNA885753	3875	250	0.881356	2.20339	Fermentimonas caenicola	1562970	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g3857	i0	99.203	1.004	251	1	100	1	1	250	2229333	2229583	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	251	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
19988373	19988373	PRJNA885753_S_NODE_3776_length_251_cov_0.876404_g3758_i0	PRJNA885753	3776	251	0.876404	2.19977404	Petrimonas mucosa	1642646	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1088721598\|emb\|LT608328.1\|	1642646	g3758	i0	100	51.8565737051793	251	0	100	0	1	251	4830	5080	Petrimonas mucosa isolate ING2-E5A genome assembly, chromosome: I	blastn	13016	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas mucosa
21263697	21263697	PRJNA885753_S_NODE_3077_length_268_cov_1.994872_g3059_i0	PRJNA885753	3077	268	1.994872	5.34625696	Spirosoma montaniterrae	1178516	Bacteria	Bacteria	202	2.3e-47	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g3059	i0	82.403	157.059701492537	233	39	87	2	14	245	3065563	3065332	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	42092	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
21263714	21263714	PRJNA885753_S_NODE_4377_length_244_cov_0.912281_g4359_i0	PRJNA885753	4377	244	0.912281	2.22596564	Xiashengella succiniciproducens	2949635	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|2250061814\|gb\|CP098400.1\|	2949635	g4359	i0	99.59	1	244	0	100	1	1	244	1602607	1602365	Xiashengella succiniciproducens strain Ai-910 chromosome, complete genome	blastn	244	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Xiashengella	Xiashengella succiniciproducens
21263717	21263717	PRJNA885753_S_NODE_4477_length_243_cov_0.917647_g4459_i0	PRJNA885753	4477	243	0.917647	2.22988221	Fermentimonas caenicola	1562970	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4459	i0	98.765	1	243	3	100	0	1	243	2493407	2493649	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	243	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
24192875	24192875	PRJNA885753_S_NODE_3459_length_257_cov_1.173913_g3441_i0	PRJNA885753	3459	257	1.173913	3.01695641	Porphyromonas	836	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2665661841\|gb\|CP143258.1\|	867595	g3441	i0	99.611	2	257	1	100	0	1	257	2250115	2250371	Porphyromonas pogonae strain PP01-1 chromosome, complete genome	blastn	514	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pogonae
25087779	25087779	PRJNA885753_S_NODE_1540_length_352_cov_0.838710_g1522_i0	PRJNA885753	1540	352	0.83871	2.9522592	Fermentimonas caenicola	1562970	Bacteria	Bacteria	645	1.2e-180	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g1522	i0	99.716	1	352	1	100	0	1	352	1818882	1819233	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	352	645	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
25087818	25087818	PRJNA885753_S_NODE_4200_length_246_cov_0.901734_g4182_i0	PRJNA885753	4200	246	0.901734	2.21826564	Fermentimonas caenicola	1562970	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4182	i0	99.187	1	246	2	100	0	1	246	268317	268072	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	246	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola

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