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

14 rows where analysis = "blastn", bioproject = "PRJNA529241" and tax_kingdom = "Bamfordvirae"

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
1116038	1116038	PRJNA529241_P_NODE_47121_length_297_cov_4.223077_g44799_i0	PRJNA529241	47121	297	4.223077	12.54253869	root	1	Root_unresolved	Root_unresolved	390	5.149999999999999e-104	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g44799	i0	100	96.4781144781145	211	0	97	0	1	211	13170	12960	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	28654	390	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
3666173	3666173	PRJNA529241_P_NODE_17623_length_536_cov_33.222445_g15502_i0	PRJNA529241	17623	536	33.222445	178.0723052	root	1	Root_unresolved	Root_unresolved	981	0	NTclustered	gi\|2620236085\|gb\|OR777220.1\|	10515	g15502	i0	100	99.0671641791045	531	0	99	0	6	536	15223	14693	Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome	blastn	53100	981	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
6218288	6218288	PRJNA529241_P_NODE_13925_length_649_cov_34.676471_g11996_i0	PRJNA529241	13925	649	34.676471	225.05029679	root	1	Root_unresolved	Root_unresolved	900	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g11996	i0	99.595	96.6101694915254	494	1	96	1	6	498	11646	11153	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	62700	905	0.994475138121547	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
6219186	6219186	PRJNA529241_P_NODE_34985_length_347_cov_4.632258_g32666_i0	PRJNA529241	34985	347	4.632258	16.07393526	root	1	Root_unresolved	Root_unresolved	150	1.1299999999999998e-31	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g32666	i0	100	81.3025936599424	81	0	88	0	94	174	15720	15800	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	28212	150	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
7494361	7494361	PRJNA529241_P_NODE_50186_length_288_cov_7.904382_g47864_i0	PRJNA529241	50186	288	7.904382	22.76462016	root	1	Root_unresolved	Root_unresolved	425	1.36e-114	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g47864	i0	92.605	107.986111111111	311	0	100	1	1	288	13743	13433	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	31100	425	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
10043279	10043279	PRJNA529241_P_NODE_137108_length_192_cov_4.606452_g134786_i0	PRJNA529241	137108	192	4.606452	8.84438784	root	1	Root_unresolved	Root_unresolved	196	7.22e-46	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g134786	i0	100	94.3645833333333	106	0	95	0	1	106	16581	16476	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	18118	196	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
15143043	15143043	PRJNA529241_P_NODE_17672_length_535_cov_11.339357_g15180_i1	PRJNA529241	17672	535	11.339357	60.66555995	root	1	Root_unresolved	Root_unresolved	662	0	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g15180	i1	100	97.9439252336449	358	0	98	0	177	534	17765	17408	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	52400	662	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
16417686	16417686	PRJNA529241_P_NODE_17293_length_544_cov_12.913215_g15180_i0	PRJNA529241	17293	544	12.913215	70.2478896	root	1	Root_unresolved	Root_unresolved	983	0	NTclustered	gi\|2079660852\|emb\|OU501478.1\|	10515	g15180	i0	99.813	98.3511029411765	535	1	98	0	9	543	17915	17381	Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE	blastn	53503	983	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
16418766	16418766	PRJNA529241_P_NODE_433873_length_162_cov_97.016000_g431551_i0	PRJNA529241	433873	162	97.016	157.16592	root	1	Root_unresolved	Root_unresolved	300	4.36e-77	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g431551	i0	100	100	162	0	100	0	1	162	18143	18304	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	16200	300	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
18353957	18353957	PRJNA529241_P_NODE_7855_length_1081_cov_2.880268_g6617_i0	PRJNA529241	7855	1081	2.880268	31.13569708	Megavirus powaiense	3060302	Viruses	Viruses	60.2	6.57e-4	NTclustered	gi\|2500352667\|ref\|NC_075034.1\|	1842663	g6617	i0	97.143	0.112858464384829	35	1	3	0	616	650	266623	266589	Powai lake megavirus isolate 1, complete genome	blastn	122	60.2	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Megavirus	Megavirus powaiense
24067267	24067267	PRJNA529241_P_NODE_27299_length_399_cov_4.077348_g24998_i0	PRJNA529241	27299	399	4.077348	16.26861852	root	1	Root_unresolved	Root_unresolved	267	1.25e-66	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g24998	i0	98.052	98.7167919799499	154	2	94	1	137	290	12325	12173	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	39388	267	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
24067361	24067361	PRJNA529241_P_NODE_29819_length_379_cov_3.953216_g27510_i0	PRJNA529241	29819	379	3.953216	14.98268864	root	1	Root_unresolved	Root_unresolved	291	7.03e-74	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g27510	i0	100	91.0052770448549	157	0	91	0	87	243	12169	12325	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	34491	291	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
24067852	24067852	PRJNA529241_P_NODE_404079_length_172_cov_3.777778_g401757_i0	PRJNA529241	404079	172	3.777778	6.49777816	root	1	Root_unresolved	Root_unresolved	318	1.2899999999999999e-82	NTclustered	gi\|2452970428\|gb\|OQ518271.1\|	10515	g401757	i0	100	100	172	0	100	0	1	172	13150	13321	Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome	blastn	17200	318	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari
24068021	24068021	PRJNA529241_P_NODE_450519_length_156_cov_5.067227_g448197_i0	PRJNA529241	450519	156	5.067227	7.90487412	root	1	Root_unresolved	Root_unresolved	289	9e-74	NTclustered	gi\|2079660852\|emb\|OU501478.1\|	10515	g448197	i0	100	100	156	0	100	0	1	156	12590	12745	Human adenovirus 2 isolate ADVJA-00-BE genome assembly, chromosome: ADVJA-00-BE	blastn	15600	289	1	Viruses	Bamfordvirae	Preplasmiviricota	Pharingeaviricetes	Rowavirales	Adenoviridae	Mastadenovirus	Mastadenovirus caesari

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