metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB15333" 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
4813677	4813677	PRJEB15333_P_NODE_17264_length_168_cov_1.747899_g17180_i0	PRJEB15333	17264	168	1.747899	2.93647032	Cytophaga	978	Bacteria	Bacteria	239	1.01e-58	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g17180	i0	92.308	256.767857142857	169	12	100	1	1	168	66	234	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	43137	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
6088949	6088949	PRJEB15333_P_NODE_5985_length_269_cov_1.250000_g5901_i0	PRJEB15333	5985	269	1.25	3.3625	Leadbetterella	319458	Bacteria	Bacteria	209	1.38e-49	NTclustered	gi\|470487076\|ref\|NR_076799.1\|	316068	g5901	i0	81.091	308.985130111524	275	40	100	12	1	269	501	233	Leadbetterella byssophila strain 4M15 23S ribosomal RNA gene, complete sequence	blastn	83117	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella byssophila
7673868	7673868	PRJEB15333_P_NODE_18767_length_165_cov_2.620690_g18683_i0	PRJEB15333	18767	165	2.62069	4.3241385	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g18683	i0	92.727	335.993939393939	165	12	100	0	1	165	217218	217054	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	55439	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
8638923	8638923	PRJEB15333_P_NODE_17287_length_168_cov_1.579832_g17203_i0	PRJEB15333	17287	168	1.579832	2.65411776	Aquirufa	2676247	Bacteria	Bacteria	246	6.03e-61	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g17203	i0	97.887	254.690476190476	142	3	98	0	4	145	359717	359858	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	42788	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
10224355	10224355	PRJEB15333_P_NODE_13449_length_187_cov_2.166667_g13365_i0	PRJEB15333	13449	187	2.166667	4.05166729	Arcticibacter sp. MXS-1	3341726	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|2802081668\|gb\|CP169244.1\|	3341726	g13365	i0	91.304	319.27807486631	184	16	98	0	4	187	2251033	2251216	Arcticibacter sp. MXS-1 chromosome, complete genome	blastn	59705	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Arcticibacter	Arcticibacter sp. MXS-1
11189187	11189187	PRJEB15333_P_NODE_20149_length_163_cov_0.912281_g20065_i0	PRJEB15333	20149	163	0.912281	1.48701803	Cloacibacterium	501783	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g20065	i0	98.773	9.76073619631902	163	2	100	0	1	163	2595696	2595534	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1591	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12465002	12465002	PRJEB15333_P_NODE_21250_length_158_cov_2.055046_g21166_i0	PRJEB15333	21250	158	2.055046	3.24697268	Pedobacter	84567	Bacteria	Bacteria	193	7.38e-45	NTclustered	gi\|2738722518\|gb\|CP157278.1\|	1503925	g21166	i0	90	208.455696202532	150	14	94	1	1	149	2592470	2592619	Pedobacter lusitanus strain NL19 chromosome, complete genome	blastn	32936	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter lusitanus
22662777	22662777	PRJEB15333_P_NODE_7858_length_238_cov_2.952381_g7774_i0	PRJEB15333	7858	238	2.952381	7.02666678	Chryseobacterium	59732	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g7774	i0	100	489.773109243697	238	0	100	0	1	238	2627119	2626882	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	116566	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense

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