metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_phylum = "Verrucomicrobiota"

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
1409818	1409818	PRJEB7366_P_NODE_12502_length_227_cov_2.708333_g12068_i0	PRJEB7366	12502	227	2.708333	6.14791591	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12068	i0	94.545	78.1850220264317	220	12	97	0	1	220	1403941	1403722	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17748	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
1409819	1409819	PRJEB7366_P_NODE_12782_length_224_cov_1.904762_g12348_i0	PRJEB7366	12782	224	1.904762	4.26666688	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	327	2.95e-85	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12348	i0	92.92	141.946428571429	226	14	100	1	1	224	1405134	1405359	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	31796	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
3546110	3546110	PRJEB7366_P_NODE_5723_length_374_cov_2.353982_g5290_i0	PRJEB7366	5723	374	2.353982	8.80389268	Opitutaceae	134623	Bacteria	Bacteria	669	0	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g5290	i0	98.93	196.580213903743	374	4	100	0	1	374	541410	541783	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	73521	675	0.991111111111111	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
5237805	5237805	PRJEB7366_P_NODE_20385_length_168_cov_2.045113_g19951_i0	PRJEB7366	20385	168	2.045113	3.43578984	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g19951	i0	96.104	206.357142857143	154	5	91	1	1	153	1403983	1404136	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	34668	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
7373081	7373081	PRJEB7366_P_NODE_21286_length_164_cov_1.534884_g20852_i0	PRJEB7366	21286	164	1.534884	2.51720976	Verrucomicrobiales	48461	Bacteria	Bacteria	130	6.15e-26	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g20852	i0	81.437	128.90243902439	167	24	99	7	1	163	3411503	3411666	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21140	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9062500	9062500	PRJEB7366_P_NODE_11688_length_237_cov_3.366337_g11254_i0	PRJEB7366	11688	237	3.366337	7.97821869	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	348	2.4200000000000006e-91	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g11254	i0	93.939	32.3122362869198	231	13	97	1	1	231	1404909	1405138	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	7658	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
16711911	16711911	PRJEB7366_P_NODE_14334_length_208_cov_2.080925_g13900_i0	PRJEB7366	14334	208	2.080925	4.328324	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	351	1.6e-92	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g13900	i0	97.115	82.3413461538462	208	6	100	0	1	208	1404306	1404513	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17127	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
17986867	17986867	PRJEB7366_P_NODE_6615_length_342_cov_1.638436_g6181_i0	PRJEB7366	6615	342	1.638436	5.60345112	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	399	1e-106	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g6181	i0	87.941	127.345029239766	340	39	99	2	1	339	3991679	3992017	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	43552	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
19260871	19260871	PRJEB7366_P_NODE_7936_length_305_cov_2.088889_g7502_i0	PRJEB7366	7936	305	2.088889	6.37111145	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g7502	i0	99.672	97.5967213114754	305	1	100	0	1	305	1404828	1404524	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	29767	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
20536134	20536134	PRJEB7366_P_NODE_14457_length_207_cov_1.802326_g14023_i0	PRJEB7366	14457	207	1.802326	3.73081482	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	200	6.109999999999998e-47	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g14023	i0	91.724	178.299516908213	145	11	70	1	61	204	3990067	3990211	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36908	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium

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