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

10 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax_kingdom = "Orthornavirae"

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
594880	594880	PRJNA615175_P_NODE_1_length_9040_cov_85.556039_g0_i0	PRJNA615175	1	9040	85.556039	7734.2659256	Cripavirus drosophilae	3047809	Viruses	Viruses	15546	0	NTclustered	gi\|2714662726\|gb\|OR820583.1\|	64279	g0	i0	97.886	21.1269911504425	8989	189	99	1	1	8988	270	9258	Drosophila C virus isolate Davidson2006, complete genome	blastn	190988	15546	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae	Cripavirus	Cripavirus drosophilae
595191	595191	PRJNA615175_P_NODE_4261_length_751_cov_37.986726_g4102_i0	PRJNA615175	4261	751	37.986726	285.28031226	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.021	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g4102	i0	100	0.0386151797603196	29	0	4	0	1	29	13	41	Carnation latent virus isolate KL, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
6973146	6973146	PRJNA615175_P_NODE_10626_length_448_cov_2.842667_g10458_i0	PRJNA615175	10626	448	2.842667	12.73514816	Canine astrovirus	1157338	Viruses	Viruses	795	0	NTclustered	gi\|1917349463\|gb\|MN882008.1\|	1157338	g10458	i0	98.661	67.578125	448	6	100	0	1	448	6425	5978	Canine astrovirus strain B091/China/GZ/2018, complete genome	blastn	30275	795	1	Viruses	Orthornavirae	Pisuviricota	Stelpaviricetes	Stellavirales	Astroviridae	Mamastrovirus	Canine astrovirus
6973614	6973614	PRJNA615175_P_NODE_4906_length_697_cov_47.615385_g4102_i1	PRJNA615175	4906	697	47.615385	331.87923345	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.019	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g4102	i1	100	0.0416068866571019	29	0	4	0	1	29	13	41	Carnation latent virus isolate KL, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
8248318	8248318	PRJNA615175_P_NODE_4027_length_775_cov_3.414530_g3871_i0	PRJNA615175	4027	775	3.41453	26.4626075	Skokie dicistro-like virus	2789443	Viruses	Viruses	1387	0	NTclustered	gi\|2806502719\|gb\|PQ054859.1\|	2789443	g3871	i0	98.968	2	775	8	100	0	1	775	5259	4485	MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence	blastn	1550	1387	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Skokie dicistro-like virus
9523405	9523405	PRJNA615175_P_NODE_2588_length_959_cov_113.399549_g2172_i1	PRJNA615175	2588	959	113.399549	1087.50167491	Jujube closterovirus 1	3043313	Viruses	Viruses	56.5	0.008	NTclustered	gi\|2496749738\|gb\|OP673405.1\|	3043313	g2172	i1	100	0.0312825860271116	30	0	3	0	1	30	6	35	Jujube closterovirus 1 isolate AKS15-20, complete genome	blastn	30	56.5	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae		Jujube closterovirus 1
14623935	14623935	PRJNA615175_P_NODE_3032_length_893_cov_8.103659_g2896_i0	PRJNA615175	3032	893	8.103659	72.36567487	Carlavirus latensdianthi	3427766	Viruses	Viruses	54.7	0.025	NTclustered	gi\|1995060321\|gb\|MN450069.1\|	12164	g2896	i0	100	0.032474804031355	29	0	3	0	865	893	41	13	Carnation latent virus isolate KL, complete genome	blastn	29	54.7	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus latensdianthi
15897965	15897965	PRJNA615175_P_NODE_3173_length_873_cov_117.415000_g2172_i2	PRJNA615175	3173	873	117.415	1025.03295	Jujube closterovirus 1	3043313	Viruses	Viruses	56.5	0.007	NTclustered	gi\|2496749738\|gb\|OP673405.1\|	3043313	g2172	i2	100	0.0343642611683849	30	0	3	0	844	873	35	6	Jujube closterovirus 1 isolate AKS15-20, complete genome	blastn	30	56.5	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae		Jujube closterovirus 1
18447228	18447228	PRJNA615175_P_NODE_755_length_1560_cov_6.000000_g698_i0	PRJNA615175	755	1560	6	93.6	Leptosphaeria biglobosa letobirnavirus 1	3062763	Viruses	Viruses	2582	0	NTclustered	gi\|2550190979\|gb\|OQ650197.1\|	3062763	g698	i0	96.538	19.9371794871795	1560	54	100	0	1	1560	1725	166	Leptosphaeria biglobosa letobirnavirus 1 isolate NN8-42 segment RNA2 coat protein gene, complete cds	blastn	31102	2582	1	Viruses	Orthornavirae				Birnaviridae		Leptosphaeria biglobosa letobirnavirus 1
19721301	19721301	PRJNA615175_P_NODE_10376_length_455_cov_2.520942_g10208_i0	PRJNA615175	10376	455	2.520942	11.4702861	Chrocaferb virus	3129387	Viruses	Viruses	202	4.14e-47	NTclustered	gi\|2717317453\|gb\|PP171835.1\|	3129387	g10208	i0	79.592	26.5054945054945	294	50	64	10	156	446	565	279	MAG: Chrocaferb virus isolate CC1A_k141_77359 genomic sequence	blastn	12060	202	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes				Chrocaferb virus

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