metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA415856" and tax_superkingdom = "Archaea"

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
419232	419232	PRJNA415856_P_NODE_23501_length_186_cov_1.489051_g23240_i0	PRJNA415856	23501	186	1.489051	2.76963486	Methanobrevibacter millerae	230361	Archaea	Archaea	281	1.86e-71	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g23240	i0	94.054	68.6881720430108	185	11	99	0	1	185	541982	542166	Methanobrevibacter millerae strain SM9, complete genome	blastn	12776	281	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
1694175	1694175	PRJNA415856_P_NODE_362_length_1443_cov_4.523673_g283_i0	PRJNA415856	362	1443	4.523673	65.27660139	uncultured archaeon	115547	Archaea	Archaea	2505	0	NTclustered	gi\|326537486\|gb\|JF304140.1\|	115547	g283	i0	98.521	97.3215523215523	1420	20	98	1	1	1419	15	1434	Uncultured archaeon clone 3(31) 16S ribosomal RNA gene, partial sequence	blastn	140435	2505	1	Archaea								uncultured archaeon
4246344	4246344	PRJNA415856_P_NODE_28704_length_176_cov_2.425197_g28443_i0	PRJNA415856	28704	176	2.425197	4.26834672	Methanobrevibacter millerae	230361	Archaea	Archaea	207	2.99e-49	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g28443	i0	88.068	3.04545454545455	176	20	100	1	1	176	542826	543000	Methanobrevibacter millerae strain SM9, complete genome	blastn	536	207	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
10623310	10623310	PRJNA415856_P_NODE_47749_length_163_cov_0.894737_g47488_i0	PRJNA415856	47749	163	0.894737	1.45842131	Methanomassiliicoccaceae archaeon DOK	1535962	Archaea	Archaea	279	5.73e-71	NTclustered	gi\|1799215713\|gb\|CP047880.1\|	1535962	g47488	i0	97.546	1	163	4	100	0	1	163	1513968	1514130	Methanomassiliicoccaceae archaeon DOK chromosome, complete genome	blastn	163	279	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata	Methanomassiliicoccales	Methanomassiliicoccaceae		Methanomassiliicoccaceae archaeon DOK
11286582	11286582	PRJNA415856_P_NODE_1169_length_910_cov_4.167247_g1003_i0	PRJNA415856	1169	910	4.167247	37.9219477	Nitrososphaera	497726	Archaea	Archaea	1123	0	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g1003	i0	89.207	52.810989010989	908	87	99	10	6	909	921	21	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	48058	1123	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
12562350	12562350	PRJNA415856_P_NODE_8090_length_321_cov_4.080882_g7829_i0	PRJNA415856	8090	321	4.080882	13.09963122	Candidatus Nitrosocosmicus	1826864	Archaea	Archaea	503	6.92e-138	NTclustered	gi\|388254672\|gb\|JQ768092.1\|	115547	g7829	i0	95	85.1557632398754	320	16	99	0	2	321	27206	27525	Uncultured archaeon clone 02j05, complete sequence	blastn	27335	503	1	Archaea								uncultured archaeon
13173068	13173068	PRJNA415856_P_NODE_311_length_1522_cov_3.315682_g241_i0	PRJNA415856	311	1522	3.315682	50.46468004	uncultured crenarchaeote	29281	Archaea	Archaea	2206	0	NTclustered	gi\|22797874\|emb\|AJ496176.1\|	29281	g241	i0	92.857	102.687253613666	1526	99	100	8	1	1522	6919	8438	Uncultured crenarchaeote 34 kb genomic fragment	blastn	156290	2206	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
17660934	17660934	PRJNA415856_P_NODE_23354_length_186_cov_2.321168_g23093_i0	PRJNA415856	23354	186	2.321168	4.31737248	root	1	Root_unresolved	Root_unresolved	344	2.34e-90	NTclustered	gi\|1294447101\|gb\|CP017803.1\|	2173	g23093	i0	100	179.618279569892	186	0	100	0	1	186	266643	266458	Methanobrevibacter smithii strain KB11 chromosome, complete genome	blastn	33409	344	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii
17660962	17660962	PRJNA415856_P_NODE_2674_length_611_cov_26.439502_g2436_i0	PRJNA415856	2674	611	26.439502	161.54535722	root	1	Root_unresolved	Root_unresolved	1088	0	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g2436	i0	98.852	398.576104746318	610	7	99	0	1	610	3115894	3116503	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	243530	1088	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.
20821033	20821033	PRJNA415856_P_NODE_30377_length_174_cov_1.224000_g30116_i0	PRJNA415856	30377	174	1.224	2.12976	Methanobrevibacter sp. YE315	1609968	Archaea	Archaea	298	1.7e-76	NTclustered	gi\|985614202\|gb\|CP010834.1\|	1609968	g30116	i0	97.701	105	174	3	100	1	1	174	497437	497265	Methanobrevibacter sp. YE315, complete genome	blastn	18270	298	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp. YE315
21485364	21485364	PRJNA415856_P_NODE_9657_length_287_cov_2.310924_g9396_i0	PRJNA415856	9657	287	2.310924	6.63235188	Nitrososphaera	497726	Archaea	Archaea	479	1.0299999999999996e-130	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g9396	i0	97.5	42.3728222996516	280	7	98	0	6	285	921	642	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	12161	479	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
25309521	25309521	PRJNA415856_P_NODE_17720_length_207_cov_1.094937_g17459_i0	PRJNA415856	17720	207	1.094937	2.26651959	Nitrososphaera	497726	Archaea	Archaea	316	5.819999999999998e-82	NTclustered	gi\|300521484\|gb\|GU797787.1\|	497727	g17459	i0	94.203	36.0821256038647	207	12	100	0	1	207	1772	1566	Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence	blastn	7469	316	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
25309582	25309582	PRJNA415856_P_NODE_26960_length_179_cov_3.115385_g26699_i0	PRJNA415856	26960	179	3.115385	5.57653915	Nitrososphaera	497726	Archaea	Archaea	274	2.97e-69	NTclustered	gi\|388254672\|gb\|JQ768092.1\|	115547	g26699	i0	94.382	23.9608938547486	178	10	99	0	2	179	29066	29243	Uncultured archaeon clone 02j05, complete sequence	blastn	4289	274	1	Archaea								uncultured archaeon
25309718	25309718	PRJNA415856_P_NODE_52100_length_161_cov_0.910714_g51839_i0	PRJNA415856	52100	161	0.910714	1.46624954	Methanobrevibacter	2172	Archaea	Archaea	298	1.56e-76	NTclustered	gi\|2791693311\|gb\|CP144200.1\|	2173	g51839	i0	100	102.422360248447	161	0	100	0	1	161	1474687	1474527	Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome	blastn	16490	298	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter smithii

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