metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Nitrososphaerota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6394992	6394992	PRJEB11748_P_NODE_252146_length_245_cov_9.119565_g249963_i0	PRJEB11748	252146	245	9.119565	22.34293425	Candidatus Nitrosocosmicus oleophilus	1353260	Archaea	Archaea	375	1.16e-99	NTclustered	gi\|937513727\|gb\|CP012850.1\|	1353260	g249963	i0	96.476	1.04489795918367	227	8	93	0	1	227	527817	528043	Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome	blastn	256	375	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus oleophilus
12769549	12769549	PRJEB11748_P_NODE_207451_length_277_cov_10.925926_g205268_i0	PRJEB11748	207451	277	10.925926	30.26481502	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	259	1.4e-64	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g205268	i0	87.281	0.924187725631769	228	28	82	1	24	250	260806	261033	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	256	259	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
12771424	12771424	PRJEB11748_P_NODE_305411_length_217_cov_1.782051_g303228_i0	PRJEB11748	305411	217	1.782051	3.86705067	uncultured Nitrososphaerales archaeon	1740634	Archaea	Archaea	99	2.43e-16	NTclustered	gi\|2874254077\|emb\|OY970160.1\|	1740634	g303228	i0	77.987	0.732718894009217	159	33	72	2	48	204	1195444	1195602	MAG: uncultured Nitrososphaerales archaeon isolate MFD09222.bin.1.114 genome assembly, chromosome: 1	blastn	159	99	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			uncultured Nitrososphaerales archaeon
14041899	14041899	PRJEB11748_P_NODE_102492_length_412_cov_6.792023_g100321_i0	PRJEB11748	102492	412	6.792023	27.98313476	Candidatus Nitrosotenuis sp. DW1	2259672	Archaea	Archaea	455	2.5800000000000003e-123	NTclustered	gi\|1869227213\|gb\|CP030846.1\|	2259672	g100321	i0	88.71	1.80825242718447	372	42	90	0	22	393	1731878	1731507	Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome	blastn	745	455	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis sp. DW1
16591692	16591692	PRJEB11748_P_NODE_147414_length_338_cov_7.162455_g145233_i0	PRJEB11748	147414	338	7.162455	24.2090979	uncultured marine thaumarchaeote AD1000_100_C06	1455887	Archaea	Archaea	540	5.59e-149	NTclustered	gi\|663500052\|gb\|KF900324.1\|	1455887	g145233	i0	99.661	0.872781065088757	295	1	87	0	24	318	38339	38045	Uncultured marine thaumarchaeote AD1000_100_C06 genomic sequence	blastn	295	540	1	Archaea	Thermoproteati	Nitrososphaerota					uncultured marine thaumarchaeote AD1000_100_C06
17872159	17872159	PRJEB11748_P_NODE_94555_length_430_cov_4.520325_g92387_i0	PRJEB11748	94555	430	4.520325	19.4373975	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	287	1.04e-72	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g92387	i0	80.311	0.897674418604651	386	70	89	6	20	402	567228	567610	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	386	287	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
20418504	20418504	PRJEB11748_P_NODE_306217_length_216_cov_10.154839_g304034_i0	PRJEB11748	306217	216	10.154839	21.93445224	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	241	3.79e-59	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g304034	i0	88.442	2.76388888888889	199	23	92	0	16	214	1155027	1155225	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	597	241	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
21695445	21695445	PRJEB11748_P_NODE_358198_length_193_cov_10.568182_g356015_i0	PRJEB11748	358198	193	10.568182	20.39659126	Nitrosarchaeum sp. AC2	2259673	Archaea	Archaea	130	7.470000000000001e-26	NTclustered	gi\|1869229208\|gb\|CP030847.1\|	2259673	g356015	i0	82.993	0.761658031088083	147	22	76	3	47	192	1311409	1311553	Nitrosarchaeum sp. AC2 chromosome, complete genome	blastn	147	130	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosarchaeum	Nitrosarchaeum sp. AC2
24244913	24244913	PRJEB11748_P_NODE_384360_length_176_cov_6.878261_g382177_i0	PRJEB11748	384360	176	6.878261	12.10573936	Candidatus Nitrosopumilus sp. SW	2508726	Archaea	Archaea	176	8.44e-40	NTclustered	gi\|1699461107\|gb\|CP035425.1\|	2508726	g382177	i0	87.5	0.863636363636364	152	19	86	0	3	154	1088243	1088092	Candidatus Nitrosopumilus sp. SW chromosome, complete genome	blastn	152	176	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Candidatus Nitrosopumilus sp. SW

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