metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
474525	474525	PRJNA493828_P_NODE_14321_length_311_cov_2.697479_g13902_i0	PRJNA493828	14321	311	2.697479	8.38915969	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	279	1.22e-70	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g13902	i0	100	0.967845659163987	151	0	97	0	1	151	2245927	2245777	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	301	279	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
3025533	3025533	PRJNA493828_P_NODE_24583_length_272_cov_1.527638_g24164_i0	PRJNA493828	24583	272	1.527638	4.15517536	Methanobrevibacter millerae	230361	Archaea	Archaea	460	3.5e-125	NTclustered	gi\|968564921\|gb\|CP011266.1\|	230361	g24164	i0	97.091	137.525735294118	275	5	100	1	1	272	541931	542205	Methanobrevibacter millerae strain SM9, complete genome	blastn	37407	460	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter millerae
3657735	3657735	PRJNA493828_P_NODE_3303_length_588_cov_44.064078_g2952_i0	PRJNA493828	3303	588	44.064078	259.09677864	Thermoproteati	1783275	Archaea	Archaea	1081	0	NTclustered	gi\|82618470\|gb\|DQ278118.1\|	29281	g2952	i0	100	97.9591836734694	585	0	99	0	4	588	1373	789	Uncultured crenarchaeote clone OdenA-100ii 16S ribosomal RNA gene, partial sequence; and 16S-23S ribosomal RNA intergenic spacer, complete sequence	blastn	57600	1081	1	Archaea		Thermoproteati	Thermoproteota					uncultured crenarchaeote
8127952	8127952	PRJNA493828_P_NODE_43727_length_227_cov_3.597403_g43308_i0	PRJNA493828	43727	227	3.597403	8.16610481	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	409	1.04e-109	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g43308	i0	99.119	1	227	2	100	0	1	227	2056284	2056058	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	227	409	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
11953704	11953704	PRJNA493828_P_NODE_50_length_2949_cov_48.750695_g30_i0	PRJNA493828	50	2949	48.750695	1437.65799555	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	5435	0	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g30	i0	99.932	86.9593082400814	2949	2	100	0	1	2949	1967898	1970846	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	256443	5435	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
17051971	17051971	PRJNA493828_P_NODE_25094_length_270_cov_2.304569_g24675_i0	PRJNA493828	25094	270	2.304569	6.2223363	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	427	3.5199999999999993e-115	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g24675	i0	95.185	1	270	13	100	0	1	270	2059163	2059432	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	270	427	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
17052234	17052234	PRJNA493828_P_NODE_43794_length_227_cov_2.941558_g43375_i0	PRJNA493828	43794	227	2.941558	6.67733666	Candidatus Nitrosocosmicus arcticus	2035267	Archaea	Archaea	316	6.489999999999998e-82	NTclustered	gi\|1241355791\|gb\|KX863713.1\|	2035267	g43375	i0	93.056	80.6607929515419	216	15	95	0	1	216	313	98	Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence	blastn	18310	316	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus arcticus
18326157	18326157	PRJNA493828_P_NODE_16015_length_310_cov_2.535865_g15596_i0	PRJNA493828	16015	310	2.535865	7.8611815	Candidatus Nitrososphaera gargensis	497727	Archaea	Archaea	84.2	1.03e-11	NTclustered	gi\|408363220\|gb\|CP002408.1\|	1237085	g15596	i0	96.078	0.82258064516129	51	2	16	0	258	308	2678420	2678370	Candidatus Nitrososphaera gargensis Ga9.2, complete genome	blastn	255	84.2	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Candidatus Nitrososphaera gargensis
18326307	18326307	PRJNA493828_P_NODE_25375_length_269_cov_3.158163_g24956_i0	PRJNA493828	25375	269	3.158163	8.49545847	Halalkalicoccus salilacus	3117459	Archaea	Archaea	497	2.63e-136	NTclustered	gi\|2674869203\|gb\|CP144461.1\|	3117459	g24956	i0	100	134.405204460967	269	0	100	0	1	269	3202265	3201997	Halalkalicoccus salilacus strain FCH27 chromosome, complete genome	blastn	36155	497	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Halococcaceae	Halalkalicoccus	Halalkalicoccus salilacus
19600571	19600571	PRJNA493828_P_NODE_26156_length_267_cov_1.582474_g25737_i0	PRJNA493828	26156	267	1.582474	4.22520558	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	483	7.31e-132	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g25737	i0	99.251	1	267	2	100	0	1	267	1353702	1353436	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	267	483	1	Archaea		Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
19600653	19600653	PRJNA493828_P_NODE_31456_length_252_cov_2.022346_g31037_i0	PRJNA493828	31456	252	2.022346	5.09631192	Candidatus Nitrosocosmicus hydrocola	1826872	Archaea	Archaea	459	1.1499999999999996e-124	NTclustered	gi\|1100598057\|gb\|CP017922.1\|	1826872	g31037	i0	99.602	0.996031746031746	251	1	99	0	2	252	1853227	1853477	Candidatus Nitrosocosmicus hydrocola strain G61, complete genome	blastn	251	459	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus hydrocola
20876554	20876554	PRJNA493828_P_NODE_35837_length_246_cov_0.890173_g35418_i0	PRJNA493828	35837	246	0.890173	2.18982558	uncultured euryarchaeote	114243	Archaea	Archaea	433	6.79e-117	NTclustered	gi\|196122313\|gb\|EU888367.1\|	114243	g35418	i0	98.387	100.731707317073	248	0	100	4	1	246	788	543	Uncultured euryarchaeote clone Q14 16S ribosomal RNA gene, partial sequence	blastn	24780	433	1	Archaea		Methanobacteriati	Methanobacteriota					uncultured euryarchaeote
23427453	23427453	PRJNA493828_P_NODE_6399_length_437_cov_259.164835_g5999_i0	PRJNA493828	6399	437	259.164835	1132.55032895	uncultured Methanoregula sp.	1005933	Archaea	Archaea	758	0	NTclustered	gi\|2621785414\|emb\|OY781872.1\|	1005933	g5999	i0	98.157	324.29290617849	434	8	99	0	4	437	3117554	3117121	MAG: uncultured Methanoregula sp. isolate a338d9b7-13de-4e9d-8f1a-cfe667c23436 genome assembly, chromosome: 1	blastn	141716	758	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanomicrobiales	Methanoregulaceae	Methanoregula	uncultured Methanoregula sp.

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